Structure

SQLUnionSubquery

A trivial copy of SQLSubquery with a different type for its subquery property.

struct SQLUnionSubquery

Overview

As with SQLCommonUnionBuilder, this type is only necessary because of design oversights made when the original support for unions was added (the way subquery support, which was not implemented at the time, would work was not anticipated, so some types got more hardcoded than was wise); we can’t fix them without breaking public API, so this annoying duplication of code is used as a workaround.

Topics

Initializers

init(SQLUnion)
Create a new subquery expression from a select query.

Instance Properties

var subquery: SQLUnion
The (sub)query.

Instance Methods

func serialize(to: inout SQLSerializer)
Invoked when a request is made to serialize the expression to raw SQL.

Relationships

Conforms To

SQLExpression
Swift.Sendable
Swift.SendableMetatype

struct SQLAlterColumnDefinitionType
A clause specifying a new data type to be applied to an existing column.
struct SQLColumnAssignment
Encapsulates a column_name=value expression in the context of an UPDATE query’s value assignment list. This is distinct from an SQLBinaryExpression using the .equal operator in that the left side must be an unqualified column name, the operator must be =, and the right side may use SQLExcludedColumn when the assignment appears in the assignments list of a SQLConflictAction.update(assignments:predicate:) specification.
enum SQLColumnConstraintAlgorithm
Column-level data constraints.
struct SQLColumnDefinition
A clause expressing a column definition, for use when creating and altering tables.
struct SQLCommonTableExpression
A clause describing a single Common Table Expressions, which in itws simplest form provides additional data to a primary query in the same way as joining to a subquery.
struct SQLCommonTableExpressionGroup
A clause representing a group of one or more SQLCommonTableExpressions.
enum SQLConflictAction
An action to take when an INSERT query encounters a unique constraint violation.
struct SQLConflictResolutionStrategy
Specifies a conflict resolution strategy and associated conditions for an INSERT query. An INSERT with a conflict strategy is often refered to as an UPSERT (“insert or update”). Databases are not required to support any given subset of upsert functionality, or any at all.
enum SQLDropBehavior
Specifies a behavior when performing a DROP operation on a database object which is referenced by other objects.
struct SQLEnumDataType
Represents a data type which specifies an enumeration in the database.
struct SQLExcludedColumn
An expression appearing on the right side of a column assignment which, when the assignment list is part of an upsert’s update acion, refers to the value which was originally to be inserted for the given column.
struct SQLForeignKey
A complete FOREIGN KEY constraint specification.
struct SQLInsertModifier
Simple helper for working around MySQL’s refusal to implement standard SQL. Only emits SQL when needed.
struct SQLJoin
Encapsulates a single SQL JOIN, specifying the join type, the right-side table, and condition.
enum SQLJoinMethod
The method used by a table join clause.