Protocol

SQLPartialResultBuilder

Common definitions for any query builder which permits specifying range and ordering behaviors.

protocol SQLPartialResultBuilder : AnyObject

Topics

Instance Properties

var limit: Int?
If set, limits the maximum number of results.
var offset: Int?
If set, offsets the results.
var orderBys: [any SQLExpression]
Zero or more ORDER BY clauses.

Instance Methods

func limit(Int?) -> Self
Adds a LIMIT clause to the query. If called more than once, the last call wins.
func offset(Int?) -> Self
Adds a OFFSET clause to the query. If called more than once, the last call wins.
func orderBy(any SQLExpression) -> Self
Adds an ORDER BY clause to the query using the specified expression.
func orderBy(_:_:)
Adds an ORDER BY clause to the query with the specified column and ordering.

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