ProjectedOrderedSubQuery<T extends Record> class final Writing queries

A SubQuery which has an order imposed by .orderBy and is projected to a new set of columns using .select (or .distinct).

A ProjectedOrderedSubQuery has the following extension methods that preserve the ordering:

• .limit,
• .offset, and,
• .distinct.

Tip

If you wish to use an ordered query in manner that disregards the ordering you can convert to an unordered SubQuery using asSubQuery. This is necessary for certain operations (like JOIN, UNION, etc.) becauses SQL disregards the order of rows in subqueries.

To use .where or .select after imposing a projection you must use asSubQuery, because these must create subqueries which discards the ordering.

Available extensions

• ProjectedOrderedSubQuery1
• ProjectedOrderedSubQuery1Ext
• ProjectedOrderedSubQuery2
• ProjectedOrderedSubQuery3
• ProjectedOrderedSubQuery4
• ProjectedOrderedSubQuery5
• ProjectedOrderedSubQuery6
• ProjectedOrderedSubQuery7
• ProjectedOrderedSubQuery8
• ProjectedOrderedSubQueryExt

Properties

asSubQuery → SubQuery<T>

Available on ProjectedOrderedSubQuery<T>, provided by the ProjectedOrderedSubQueryExt extension

Wrap this as unordered SubQuery.

no setter

first → Expr<T?>

Available on ProjectedOrderedSubQuery<(Expr<T>)>, provided by the ProjectedOrderedSubQuery1Ext extension

Use the first row of this query as subquery expression.

no setter

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

distinct() → ProjectedOrderedSubQuery<T>

Available on ProjectedOrderedSubQuery<T>, provided by the ProjectedOrderedSubQueryExt extension

Create a query with distinct rows from this query using the DISTINCT keyword.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>)>

Available on ProjectedOrderedSubQuery<(Expr<A>)>, provided by the ProjectedOrderedSubQuery1 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedSubQuery2 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedSubQuery3 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the ProjectedOrderedSubQuery4 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the ProjectedOrderedSubQuery5 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the ProjectedOrderedSubQuery6 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the ProjectedOrderedSubQuery7 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

limit(int limit) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the ProjectedOrderedSubQuery8 extension

Limit ProjectedOrderedSubQuery using LIMIT clause.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>)>

Available on ProjectedOrderedSubQuery<(Expr<A>)>, provided by the ProjectedOrderedSubQuery1 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedSubQuery2 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedSubQuery3 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the ProjectedOrderedSubQuery4 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the ProjectedOrderedSubQuery5 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the ProjectedOrderedSubQuery6 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the ProjectedOrderedSubQuery7 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

offset(int offset) → ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the ProjectedOrderedSubQuery8 extension

Offset ProjectedOrderedSubQuery using OFFSET clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a)) → OrderedSubQuery<(Expr<A>)>

Available on ProjectedOrderedSubQuery<(Expr<A>)>, provided by the ProjectedOrderedSubQuery1 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b)) → OrderedSubQuery<(Expr<A>, Expr<B>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedSubQuery2 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedSubQuery3 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the ProjectedOrderedSubQuery4 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the ProjectedOrderedSubQuery5 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the ProjectedOrderedSubQuery6 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the ProjectedOrderedSubQuery7 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the ProjectedOrderedSubQuery8 extension

Order ProjectedOrderedSubQuery using ORDER BY clause.

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited