ProjectedOrderedQuery2<A, B> extension

Extension methods for a query returning zero or more rows with 2 expressions.

on

Properties

first → QuerySingle<(Expr<A>, Expr)>: Available on ProjectedOrderedQuery<(Expr<A>, Expr)>, provided by the ProjectedOrderedQuery2 extension
Limit Query to the first row using LIMIT clause.
no setter

fetch() → Future<List<(A, B)>>: Available on ProjectedOrderedQuery<(Expr<A>, Expr)>, provided by the ProjectedOrderedQuery2 extension
Query the database for rows in this Query as a List.
limit(int limit) → ProjectedOrderedQueryRange<(Expr<A>, Expr)>: Available on ProjectedOrderedQuery<(Expr<A>, Expr)>, provided by the ProjectedOrderedQuery2 extension
Limit ProjectedOrderedQuery using LIMIT clause.
offset(int offset) → ProjectedOrderedQueryRange<(Expr<A>, Expr)>: Available on ProjectedOrderedQuery<(Expr<A>, Expr)>, provided by the ProjectedOrderedQuery2 extension
Offset ProjectedOrderedQuery using OFFSET clause.
orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr b)) → OrderedQuery<(Expr<A>, Expr)>: Available on ProjectedOrderedQuery<(Expr<A>, Expr)>, provided by the ProjectedOrderedQuery2 extension
Order ProjectedOrderedQuery using ORDER BY clause.
stream() → Stream<(A, B)>: Available on ProjectedOrderedQuery<(Expr<A>, Expr)>, provided by the ProjectedOrderedQuery2 extension
Query the database for rows in this Query as a Stream.