Enumeration

SQLDirection

Describes an ordering direction for a given sorting key.

enum SQLDirection

Topics

SQLDirection.ascending
Ascending order (minimum to maximum), as defined by the sorting key’s data type.
SQLDirection.descending
Descending order (maximum to minimum), as defined by the sorting key’s data type.
SQLDirection.notNull
NOT NULL order (non-NULL values followed by NULL values).
SQLDirection.null
NULL order (NULL values followed by non-NULL valeus).

serialize(to:)
Invoked when a request is made to serialize the expression to raw SQL.

SQLAlias
Encapsulates SQL’s <expression> [AS] <name> syntax, most often used to declare aliaed names for columns and tables.
SQLBetween
An SQLExpression which constructs SQL of the form <operand> BETWEEN <lowerBound> AND <upperBound>.
SQLColumn
An expression representing an optionally table-qualified column in an SQL table.
SQLConstraint
An expression representing the combination of a constraint name and algorithm for table constraints.
SQLDataType
Represents a value’s type in SQL.
SQLDistinct
An expression representing the subexpression of an aggregate function call which specifies whether the aggregate groups over all result rows or only distinct rows.
SQLForeignKeyAction
An expression specifying a behavior for a foreign key constraint violation.
SQLNestedSubpathExpression
A “nested subpath” expression is used to descend into the “deeper” structure of a non-scalar value, such as a dictionary, array, or JSON value.
SQLQualifiedTable
An expression representing an optionally second-level-qualified SQL table.
SQLQueryString
An expression consisting of an array of constituent subexpressions generated by custom string interpolations.