From Class Reference
From
public final class From : Query, JoinRouter, WhereRouter, GroupByRouter, OrderByRouter, LimitRouterA 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...) -> JoinsParameters
joinsThe 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]) -> JoinsParameters
joinsThe 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) -> WhereParameters
expressionThe 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...) -> GroupByParameters
expressionsThe 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]) -> GroupByParameters
expressionsThe 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...) -> OrderByParameters
orderingsThe 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]) -> OrderByParameters
orderingsThe 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) -> LimitParameters
limitThe 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?) -> LimitParameters
limitThe limit expression.
offsetThe offset expression.
Return Value
The Limit object that represents the LIMIT clause of the query.