Protocol

SQLUnqualifiedColumnListBuilder

Common definitions for query builders which permit or require specifying a list of unqualified column names.

protocol SQLUnqualifiedColumnListBuilder : AnyObject

Overview

Unqualified column lists are typically used in areas of SQL syntax where only columns belonging to the “current” table (in context) make sense, such as the initial column list of an INSERT query, the list of indexed columns for a CREATE INDEX query, or the set of columns for the UPDATE OF clause of a CREATE TRIGGER query.

For specifying aliasable columns - such as in a SELECT query - see SQLAliasedColumnListBuilder.

Topics

Instance Properties

var columnList: [any SQLExpression]

Instance Methods

func column(_:)
Specify a single column to be included in the list of columns for the query.
func columns(_:)
Specify mutiple columns to be included in the list of columns for the query.

Relationships

Inherited By

Conforming Types

See Also

Builder Protocols

protocol SQLAliasedColumnListBuilder
Common definitions for query builders which permit specifying aliased column names.
protocol SQLColumnUpdateBuilder
Common definitions for query builders which support assigning values to columns.
protocol SQLCommonTableExpressionBuilder
Common definitions for query builders which support Common Table Expressions.
protocol SQLCommonUnionBuilder
Builds SQLUnion queries. Provides common behavior for SQLUnionBuilder and SQLUnionSubqueryBuilder.
protocol SQLJoinBuilder
Common definitions for any query builder which permits specifying joins.
protocol SQLPartialResultBuilder
Common definitions for any query builder which permits specifying range and ordering behaviors.
protocol SQLPredicateBuilder
Common definitions for any query builder which permits specifying a primary predicate.
protocol SQLQueryBuilder
Base definitions for builders which set up queries and execute them against a given database.
protocol SQLQueryFetcher
Common definitions for SQLQueryBuilders which support retrieving result rows.
protocol SQLReturningBuilder
Common definitions for any query builder which can return values from data-mutating queries.
protocol SQLSecondaryPredicateBuilder
Common definitions for any query builder which permits specifying a secondary predicate.
protocol SQLSubqueryClauseBuilder
A builder which can construct - but not execute - a complete SELECT query. Useful for building CTEs, CREATE TABLE ... SELECT clauses, etc., not to mention actual SELECT queries.