Structure
SQLQualifiedTable
An expression representing an optionally second-level-qualified SQL table.
struct SQLQualifiedTable
Overview
The meaning of a second-level qualification as applied to a table is dependent on the underlying database. In PostgreSQL, a table reference is typically qualified with a schema; in MySQL or SQLite, a qualified table reference refers to an alternate database.
Topics
Initializers
init(_:space:)Create anSQLQualifiedTablefrom a name and optional second-level namespace.
Instance Properties
spaceIf specified, the second-level namespace to which the table belongs. Usually anSQLIdentifierif notnil.tableThe table name, usually anSQLIdentifier.
Instance Methods
serialize(to:)Invoked when a request is made to serialize the expression to raw SQL.
Relationships
Conforms To
SQLExpressionSwift.SendableSwift.SendableMetatype
See Also
Basic Expressions
SQLAliasEncapsulates SQL’s<expression> [AS] <name>syntax, most often used to declare aliaed names for columns and tables.SQLBetweenAnSQLExpressionwhich constructs SQL of the form<operand> BETWEEN <lowerBound> AND <upperBound>.SQLColumnAn expression representing an optionally table-qualified column in an SQL table.SQLConstraintAn expression representing the combination of a constraint name and algorithm for table constraints.SQLDataTypeRepresents a value’s type in SQL.SQLDirectionDescribes an ordering direction for a given sorting key.SQLDistinctAn expression representing the subexpression of an aggregate function call which specifies whether the aggregate groups over all result rows or only distinct rows.SQLForeignKeyActionAn expression specifying a behavior for a foreign key constraint violation.SQLNestedSubpathExpressionA “nested subpath” expression is used to descend into the “deeper” structure of a non-scalar value, such as a dictionary, array, or JSON value.SQLQueryStringAn expression consisting of an array of constituent subexpressions generated by custom string interpolations.