Skip to content

Protocol

SQLPartialResultBuilder

Common definitions for any query builder which permits specifying range and ordering behaviors.
protocol SQLPartialResultBuilder : AnyObject

Topics

Instance Properties

  • limit
    If set, limits the maximum number of results.
  • offset
    If set, offsets the results.
  • orderBys
    Zero or more ORDER BY clauses.

Instance Methods

  • limit(_:)
    Adds a LIMIT clause to the query. If called more than once, the last call wins.
  • offset(_:)
    Adds a OFFSET clause to the query. If called more than once, the last call wins.
  • orderBy(_:)
    Adds an ORDER BY clause to the query using the specified expression.
  • orderBy(_:_:)
    Adds an ORDER BY clause to the query with the specified column and ordering.

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.
  • 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.
  • SQLUnqualifiedColumnListBuilder
    Common definitions for query builders which permit or require specifying a list of unqualified column names.