From

public final class From : Query, JoinRouter, WhereRouter, GroupByRouter, OrderByRouter, LimitRouter

A From component representing a FROM clause for specifying the data source of the query.

  • Creates and chains a Joins object for specifying the JOIN clause of the query.

    Declaration

    Swift

    public func join(_ joins: JoinProtocol...) -> Joins

    Parameters

    joins

    The Join objects.

    Return Value

    The Joins object that represents the JOIN clause of the query.

  • Creates and chains a Joins object for specifying the JOIN clause of the query.

    Declaration

    Swift

    public func join(_ joins: [JoinProtocol]) -> Joins

    Parameters

    joins

    The Join objects.

    Return Value

    The Joins object that represents the JOIN clause of the query.

  • 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 a GroupBy object to group the query result.

    Declaration

    Swift

    public func groupBy(_ expressions: ExpressionProtocol...) -> GroupBy

    Parameters

    expressions

    The group by expression.

    Return Value

    The GroupBy object that represents the GROUP BY clause of the query.

  • Creates and chains a GroupBy object to group the query result.

    Declaration

    Swift

    public func groupBy(_ expressions: [ExpressionProtocol]) -> GroupBy

    Parameters

    expressions

    The group by expression.

    Return Value

    The GroupBy object that represents the GROUP 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 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.