Protocol
SQLCommonTableExpressionBuilder
Common definitions for query builders which support Common Table Expressions.
protocol SQLCommonTableExpressionBuilder : AnyObjectTopics
Instance Properties
var tableExpressionGroup: SQLCommonTableExpressionGroup?An optional group of common table expressions to include in the query under construction.
Instance Methods
func with(_:columns:as:)Specify a subquery to include as a common table expression, for use elsewhere in the overall query.func with(isRecursive: Bool, name: some SQLExpression, columns: [any SQLExpression], as: some SQLExpression) -> SelfSpecify a potentially-recursive common table expression for use elsewhere in a query.func with(recursive:columns:as:)Specify a subquery to include as a recursive common table expression, for use elsewhere in the overall query.
Relationships
Inherited By
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 SQLCommonUnionBuilderprotocol 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.