Joins

public final class Joins : Query, WhereRouter, OrderByRouter, LimitRouter

A Joins component represents a collection of the joins clauses of the query statement.

  • Creates and chains a Where object for specifying the WHERE clause of the query.

    Declaration

    Swift

    public func `where`(_ expression: ExpressionProtocol) -> Where

    Parameters

    expression

    The where expression.

    Return Value

    The Where object that represents the WHERE clause of the query.

  • Creates and chains an OrderBy object for specifying the orderings of the query result.

    Declaration

    Swift

    public func orderBy(_ orderings: OrderingProtocol...) -> OrderBy

    Parameters

    orderings

    The Ordering objects.

    Return Value

    The OrderBy object that represents the ORDER BY clause of the query.

  • Creates and chains an OrderBy object for specifying the orderings of the query result.

    Declaration

    Swift

    public func orderBy(_ orderings: [OrderingProtocol]) -> OrderBy

    Parameters

    orderings

    The Ordering objects.

    Return Value

    The OrderBy object that represents the ORDER BY clause of the query.

  • Creates and chains a Limit object to limit the number query results.

    Declaration

    Swift

    public func limit(_ limit: ExpressionProtocol) -> Limit

    Parameters

    limit

    The limit expression.

    Return Value

    The Limit object that represents the LIMIT clause of the query.

  • Creates and chains a Limit object to skip the returned results for the given offset position and to limit the number of results to not more than the given limit value.

    Declaration

    Swift

    public func limit(_ limit: ExpressionProtocol, offset: ExpressionProtocol?) -> Limit

    Parameters

    limit

    The limit expression.
    offset

    The offset expression.

    Return Value

    The Limit object that represents the LIMIT clause of the query.