Skip to content

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

Instance Methods

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

Relationships

Inherited By

Conforming Types

See Also

Builder Protocols

  • SQLAliasedColumnListBuilder
    Common definitions for query builders which permit specifying aliased column names.
  • SQLColumnUpdateBuilder
    Common definitions for query builders which support assigning values to columns.
  • SQLJoinBuilder
    Common definitions for any query builder which permits specifying joins.
  • SQLPartialResultBuilder
    Common definitions for any query builder which permits specifying range and ordering behaviors.
  • SQLPredicateBuilder
    Common definitions for any query builder which permits specifying a primary predicate.
  • SQLQueryBuilder
    Base definitions for builders which set up queries and execute them against a given database.
  • SQLQueryFetcher
    Common definitions for SQLQueryBuilders which support retrieving result rows.
  • SQLReturningBuilder
    Common definitions for any query builder which can return values from data-mutating queries.
  • SQLSecondaryPredicateBuilder
    Common definitions for any query builder which permits specifying a secondary predicate.
  • 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.