Protocol
SQLCommonUnionBuilder
protocol SQLCommonUnionBuilder : SQLPartialResultBuilderOverview
Note
This abstraction is necessary only because SQLUnionBuilder did not take the use of unions in subqueries into account in its original design; it would break public API to fix it without this workaround.
Topics
Instance Properties
var union: SQLUnionThe union query generated by this builder.
Instance Methods
func except((any SQLSubqueryClauseBuilder) throws -> any SQLSubqueryClauseBuilder) rethrows -> SelfAliasexcept(distinct:)so it acts as the “default”.func except(all:)Callexcept(all:)with a query generated by a builder.func except(distinct:)Callexcept(distinct:)with a query generated by a builder.func intersect((any SQLSubqueryClauseBuilder) throws -> any SQLSubqueryClauseBuilder) rethrows -> SelfAliasintersect(distinct:)so it acts as the “default”.func intersect(all:)Callintersect(all:)with a query generated by a builder.func intersect(distinct:)Callintersect(distinct:)with a query generated by a builder.func union((any SQLSubqueryClauseBuilder) throws -> any SQLSubqueryClauseBuilder) rethrows -> SelfAliasunion(distinct:)so it acts as the “default”.func union(all:)Callunion(all:)with a query generated by a builder.func union(distinct:)Callunion(distinct:)with a query generated by a builder.
Relationships
Inherits From
Conforming Types
See Also
Builder Protocols
protocol SQLAliasedColumnListBuilderCommon definitions for query builders which permit specifying aliased column names.protocol SQLColumnUpdateBuilderCommon definitions for query builders which support assigning values to columns.protocol SQLCommonTableExpressionBuilderCommon definitions for query builders which support Common Table Expressions.protocol SQLJoinBuilderCommon definitions for any query builder which permits specifying joins.protocol SQLPartialResultBuilderCommon definitions for any query builder which permits specifying range and ordering behaviors.protocol SQLPredicateBuilderCommon definitions for any query builder which permits specifying a primary predicate.protocol SQLQueryBuilderBase definitions for builders which set up queries and execute them against a given database.protocol SQLQueryFetcherCommon definitions forSQLQueryBuilders which support retrieving result rows.protocol SQLReturningBuilderCommon definitions for any query builder which can return values from data-mutating queries.protocol SQLSecondaryPredicateBuilderCommon definitions for any query builder which permits specifying a secondary predicate.protocol SQLSubqueryClauseBuilderA builder which can construct - but not execute - a completeSELECTquery. Useful for building CTEs,CREATE TABLE ... SELECTclauses, etc., not to mention actualSELECTqueries.protocol SQLUnqualifiedColumnListBuilderCommon definitions for query builders which permit or require specifying a list of unqualified column names.