typed_sql library

API for defining database schema and writing queries against generated code.

This library should be imported in the model.dart file where you define you database schema, which is then augmented with generated code in a model.g.dart file. For convenience, you may also wish to export this library from your model.dart file.

See topic on schema defintion for how to get started.

Classes

Aggregation<T extends Record, S extends Record> Aggregate functions
AutoIncrement Schema definition
Annotation for a field that should be auto-incremented (by default).
CustomDataType<T extends Object?> Schema definition Custom data types
Interface to be implemented by custom types that can be stored in a Row for automatic (de)-serialization.
Database<T extends Schema> Transactions
DatabaseAdapter Testing
Interface that a database adapter must implement.
DefaultValue<T> Schema definition
Annotation for a field that has a default value, specified by value.
Delete<T extends Row>
A DELETE statement deleting multiple rows.
DeleteSingle<T extends Row>
A DELETE statement deleting at-most one row.
Expr<T extends Object?> Inserting rows Writing queries Update and delete
A representation of an SQL expression with type T.
ExpressionIsNotDistinctFrom<T extends Object>
SQL Expression using IS NOT DISTINCT FROM.
ForeignKey Schema definition Foreign keys
Annotation for declaring a composite foreign key.
Group<S extends Record, T extends Record> Aggregate functions
InnerJoin<T extends Record, S extends Record> Joins
InsertSingle<T extends Row>
A INSERT statement to insert a single row.
LeftJoin<T extends Record, S extends Record> Joins
OrderedQuery<T extends Record> Writing queries
A Query which has an order imposed by .orderBy.
OrderedQueryRange<T extends Record> Writing queries
A Query which has an order imposed by .orderBy and is limited to a range by .limit or .offset.
OrderedSubQuery<T extends Record> Writing queries
A SubQuery which has an order imposed by .orderBy.
OrderedSubQueryRange<T extends Record> Writing queries
A SubQuery which has an order imposed by .orderBy and is limited to a range by .limit or .offset.
PrimaryKey Schema definition
Annotation for a table specifying its primary key.
ProjectedOrderedQuery<T extends Record> Writing queries
A Query which has an order imposed by .orderBy and is projected to a new set of columns using .select (or .distinct).
ProjectedOrderedQueryRange<T extends Record> Writing queries
A Query which has an order imposed by .orderBy, is projected to a new set of columns using .select (or .distinct), and is limited to a range by .limit or .offset.
ProjectedOrderedSubQuery<T extends Record> Writing queries
A SubQuery which has an order imposed by .orderBy and is projected to a new set of columns using .select (or .distinct).
ProjectedOrderedSubQueryRange<T extends Record> Writing queries
A SubQuery which has an order imposed by .orderBy, is projected to a new set of columns using .select (or .distinct), and is limited to a range by .limit or .offset.
Query<T extends Record> Writing queries
A Query on the database from which results can be fetched.
QuerySingle<T extends Record> Writing queries
A Query which can return at-most a single row.
References Schema definition Foreign keys
Annotation for fields that references fields from another table.
Return<T extends Record>
An SQL statement that returns zero or more rows.
ReturnOne<T extends Record>
An SQL statement that returns exactly one row.
ReturnSingle<T extends Record>
An SQL statement that returns at-most one row.
RightJoin<T extends Record, S extends Record> Joins
Row Schema definition
Marker class which all row classes must extend.
RowReader
Interface for reading rows from a database.
Schema Schema definition Migrations
Marker class which all schema definitions must extend.
SqlDialect
Interface for implementation of custom SQL dialects for package:typed_sql.
SubQuery<T extends Record> Writing queries
A Query which can only be used as a subquery.
Table<T extends Row> Inserting rows Writing queries Update and delete
A table of rows of type T.
Unique Schema definition
Annotation for a unique field.
Update<T extends Row>
A UPDATE statement to update multiple rows.
UpdateSet<T extends Row>
A set of mutations to be applied when updating rows.
UpdateSingle<T extends Row>
A UPDATE statement to update at-most one row.

Extensions

Aggregate1Project1 on Aggregation<(Expr<A>), (Expr<B>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate1Project2 on Aggregation<(Expr<A>), (Expr<B>, Expr<C>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate1Project3 on Aggregation<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate1Project4 on Aggregation<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate1Project5 on Aggregation<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate1Project6 on Aggregation<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate1Project7 on Aggregation<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate2Project1 on Aggregation<(Expr<A>, Expr<B>), (Expr<C>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate2Project2 on Aggregation<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate2Project3 on Aggregation<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate2Project4 on Aggregation<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate2Project5 on Aggregation<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate2Project6 on Aggregation<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate3Project1 on Aggregation<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate3Project2 on Aggregation<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate3Project3 on Aggregation<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate3Project4 on Aggregation<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate3Project5 on Aggregation<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate4Project1 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate4Project2 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate4Project3 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate4Project4 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate5Project1 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate5Project2 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate5Project3 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>, Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate6Project1 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate6Project2 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>, Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
Aggregate7Project1 on Aggregation<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>), (Expr<H>)>
Extension methods for specifying aggregate functions over rows in a group.
BoolExt on T
Extension methods for wrapping a bool as an expression.
CustomTypeExt on Expr<CustomDataType<S>>
Extension methods for accessing the encoded value of a custom data type expression.
CustomTypeNullableExt on Expr<CustomDataType<S>?>
Extension methods for accessing the encoded value of a custom data type expression.
DateTimeExt on T
Extension methods for wrapping a DateTime as an expression.
DoubleExt on T
Extension methods for wrapping a double as an expression.
ExpressionBool on Expr<bool>
Extension methods for bool expressions.
ExpressionDateTime on Expr<DateTime>
Extension methods for DateTime expressions.
ExpressionDouble on Expr<double>
Extension methods for double expressions.
ExpressionInt on Expr<int>
Extension methods for int expressions.
ExpressionNull on Expr<Null>
Extension methods for casting NULL to other types.
ExpressionNullable on Expr<T?>
Extension methods for casting a nullable Expr to a non-nullable Expr.
ExpressionNullableBool on Expr<bool?>
Extension methods for nullable bool expressions.
ExpressionNullableDateTime on Expr<DateTime?>
Extension methods for nullable DateTime expressions.
ExpressionNullableNum on Expr<T?>
Extension methods for nullable int and double expressions.
ExpressionNullableString on Expr<String?>
Extension methods for nullable String expressions.
ExpressionNum on Expr<T>
Extension methods for int and double expressions.
ExpressionString on Expr<String>
Extension methods for String expressions.
Group1By1 on Group<(Expr<A>), (Expr<B>)>
Extension methods for completing a GROUP BY.
Group1By2 on Group<(Expr<A>, Expr<B>), (Expr<C>)>
Extension methods for completing a GROUP BY.
Group1By3 on Group<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>)>
Extension methods for completing a GROUP BY.
Group1By4 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>)>
Extension methods for completing a GROUP BY.
Group1By5 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>)>
Extension methods for completing a GROUP BY.
Group1By6 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>)>
Extension methods for completing a GROUP BY.
Group1By7 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>), (Expr<H>)>
Extension methods for completing a GROUP BY.
Group2By1 on Group<(Expr<A>), (Expr<B>, Expr<C>)>
Extension methods for completing a GROUP BY.
Group2By2 on Group<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>)>
Extension methods for completing a GROUP BY.
Group2By3 on Group<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>)>
Extension methods for completing a GROUP BY.
Group2By4 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>)>
Extension methods for completing a GROUP BY.
Group2By5 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>)>
Extension methods for completing a GROUP BY.
Group2By6 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>, Expr<H>)>
Extension methods for completing a GROUP BY.
Group3By1 on Group<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>)>
Extension methods for completing a GROUP BY.
Group3By2 on Group<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing a GROUP BY.
Group3By3 on Group<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing a GROUP BY.
Group3By4 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing a GROUP BY.
Group3By5 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing a GROUP BY.
Group4By1 on Group<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing a GROUP BY.
Group4By2 on Group<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing a GROUP BY.
Group4By3 on Group<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing a GROUP BY.
Group4By4 on Group<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing a GROUP BY.
Group5By1 on Group<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing a GROUP BY.
Group5By2 on Group<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing a GROUP BY.
Group5By3 on Group<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing a GROUP BY.
Group6By1 on Group<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing a GROUP BY.
Group6By2 on Group<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing a GROUP BY.
Group7By1 on Group<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing a GROUP BY.
InnerJoin1On1 on InnerJoin<(Expr<A>), (Expr<B>)>
Extension methods for completing an INNER JOIN.
InnerJoin1On2 on InnerJoin<(Expr<A>), (Expr<B>, Expr<C>)>
Extension methods for completing an INNER JOIN.
InnerJoin1On3 on InnerJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>)>
Extension methods for completing an INNER JOIN.
InnerJoin1On4 on InnerJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing an INNER JOIN.
InnerJoin1On5 on InnerJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an INNER JOIN.
InnerJoin1On6 on InnerJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an INNER JOIN.
InnerJoin1On7 on InnerJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an INNER JOIN.
InnerJoin2On1 on InnerJoin<(Expr<A>, Expr<B>), (Expr<C>)>
Extension methods for completing an INNER JOIN.
InnerJoin2On2 on InnerJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>)>
Extension methods for completing an INNER JOIN.
InnerJoin2On3 on InnerJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing an INNER JOIN.
InnerJoin2On4 on InnerJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an INNER JOIN.
InnerJoin2On5 on InnerJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an INNER JOIN.
InnerJoin2On6 on InnerJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an INNER JOIN.
InnerJoin3On1 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>)>
Extension methods for completing an INNER JOIN.
InnerJoin3On2 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>)>
Extension methods for completing an INNER JOIN.
InnerJoin3On3 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an INNER JOIN.
InnerJoin3On4 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an INNER JOIN.
InnerJoin3On5 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an INNER JOIN.
InnerJoin4On1 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>)>
Extension methods for completing an INNER JOIN.
InnerJoin4On2 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>)>
Extension methods for completing an INNER JOIN.
InnerJoin4On3 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an INNER JOIN.
InnerJoin4On4 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an INNER JOIN.
InnerJoin5On1 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>)>
Extension methods for completing an INNER JOIN.
InnerJoin5On2 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>)>
Extension methods for completing an INNER JOIN.
InnerJoin5On3 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an INNER JOIN.
InnerJoin6On1 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>)>
Extension methods for completing an INNER JOIN.
InnerJoin6On2 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>, Expr<H>)>
Extension methods for completing an INNER JOIN.
InnerJoin7On1 on InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>), (Expr<H>)>
Extension methods for completing an INNER JOIN.
IntExt on T
Extension methods for wrapping an int as an expression.
LeftJoin1On1 on LeftJoin<(Expr<A>), (Expr<B>)>
Extension methods for completing an LEFT JOIN.
LeftJoin1On2 on LeftJoin<(Expr<A>), (Expr<B>, Expr<C>)>
Extension methods for completing an LEFT JOIN.
LeftJoin1On3 on LeftJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>)>
Extension methods for completing an LEFT JOIN.
LeftJoin1On4 on LeftJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing an LEFT JOIN.
LeftJoin1On5 on LeftJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an LEFT JOIN.
LeftJoin1On6 on LeftJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an LEFT JOIN.
LeftJoin1On7 on LeftJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an LEFT JOIN.
LeftJoin2On1 on LeftJoin<(Expr<A>, Expr<B>), (Expr<C>)>
Extension methods for completing an LEFT JOIN.
LeftJoin2On2 on LeftJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>)>
Extension methods for completing an LEFT JOIN.
LeftJoin2On3 on LeftJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing an LEFT JOIN.
LeftJoin2On4 on LeftJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an LEFT JOIN.
LeftJoin2On5 on LeftJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an LEFT JOIN.
LeftJoin2On6 on LeftJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an LEFT JOIN.
LeftJoin3On1 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>)>
Extension methods for completing an LEFT JOIN.
LeftJoin3On2 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>)>
Extension methods for completing an LEFT JOIN.
LeftJoin3On3 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an LEFT JOIN.
LeftJoin3On4 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an LEFT JOIN.
LeftJoin3On5 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an LEFT JOIN.
LeftJoin4On1 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>)>
Extension methods for completing an LEFT JOIN.
LeftJoin4On2 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>)>
Extension methods for completing an LEFT JOIN.
LeftJoin4On3 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an LEFT JOIN.
LeftJoin4On4 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an LEFT JOIN.
LeftJoin5On1 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>)>
Extension methods for completing an LEFT JOIN.
LeftJoin5On2 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>)>
Extension methods for completing an LEFT JOIN.
LeftJoin5On3 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an LEFT JOIN.
LeftJoin6On1 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>)>
Extension methods for completing an LEFT JOIN.
LeftJoin6On2 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>, Expr<H>)>
Extension methods for completing an LEFT JOIN.
LeftJoin7On1 on LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>), (Expr<H>)>
Extension methods for completing an LEFT JOIN.
OrderedQuery1 on OrderedQuery<(Expr<A>)>
Extension methods for a query returning zero or more rows with 1 expression.
OrderedQuery2 on OrderedQuery<(Expr<A>, Expr<B>)>
Extension methods for a query returning zero or more rows with 2 expressions.
OrderedQuery3 on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a query returning zero or more rows with 3 expressions.
OrderedQuery4 on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a query returning zero or more rows with 4 expressions.
OrderedQuery5 on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a query returning zero or more rows with 5 expressions.
OrderedQuery6 on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a query returning zero or more rows with 6 expressions.
OrderedQuery7 on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a query returning zero or more rows with 7 expressions.
OrderedQuery8 on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a query returning zero or more rows with 8 expressions.
OrderedQueryExt on OrderedQuery<T>
Extension methods for all ordered queries.
OrderedQueryRange1 on OrderedQueryRange<(Expr<A>)>
Extension methods for a query returning zero or more rows with 1 expression.
OrderedQueryRange2 on OrderedQueryRange<(Expr<A>, Expr<B>)>
Extension methods for a query returning zero or more rows with 2 expressions.
OrderedQueryRange3 on OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a query returning zero or more rows with 3 expressions.
OrderedQueryRange4 on OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a query returning zero or more rows with 4 expressions.
OrderedQueryRange5 on OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a query returning zero or more rows with 5 expressions.
OrderedQueryRange6 on OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a query returning zero or more rows with 6 expressions.
OrderedQueryRange7 on OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a query returning zero or more rows with 7 expressions.
OrderedQueryRange8 on OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a query returning zero or more rows with 8 expressions.
OrderedQueryRangeExt on OrderedQueryRange<T>
Extension methods for all ordered queries.
OrderedSubQuery1 on OrderedSubQuery<(Expr<A>)>
Extension methods for a ordered subquery of zero or more rows with 1 expression.
OrderedSubQuery1Ext on OrderedSubQuery<(Expr<T>)>
Extension methods for subqueries projected to a single expression.
OrderedSubQuery2 on OrderedSubQuery<(Expr<A>, Expr<B>)>
Extension methods for a ordered subquery of zero or more rows with 2 expressions.
OrderedSubQuery3 on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a ordered subquery of zero or more rows with 3 expressions.
OrderedSubQuery4 on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a ordered subquery of zero or more rows with 4 expressions.
OrderedSubQuery5 on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a ordered subquery of zero or more rows with 5 expressions.
OrderedSubQuery6 on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a ordered subquery of zero or more rows with 6 expressions.
OrderedSubQuery7 on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a ordered subquery of zero or more rows with 7 expressions.
OrderedSubQuery8 on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a ordered subquery of zero or more rows with 8 expressions.
OrderedSubQueryExt on OrderedSubQuery<T>
Extension methods for all ordered subqueries.
OrderedSubQueryRange1 on OrderedSubQueryRange<(Expr<A>)>
Extension methods for a ordered subquery of zero or more rows with 1 expression.
OrderedSubQueryRange1Ext on OrderedSubQueryRange<(Expr<T>)>
Extension methods for subqueries projected to a single expression.
OrderedSubQueryRange2 on OrderedSubQueryRange<(Expr<A>, Expr<B>)>
Extension methods for a ordered subquery of zero or more rows with 2 expressions.
OrderedSubQueryRange3 on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a ordered subquery of zero or more rows with 3 expressions.
OrderedSubQueryRange4 on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a ordered subquery of zero or more rows with 4 expressions.
OrderedSubQueryRange5 on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a ordered subquery of zero or more rows with 5 expressions.
OrderedSubQueryRange6 on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a ordered subquery of zero or more rows with 6 expressions.
OrderedSubQueryRange7 on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a ordered subquery of zero or more rows with 7 expressions.
OrderedSubQueryRange8 on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a ordered subquery of zero or more rows with 8 expressions.
OrderedSubQueryRangeExt on OrderedSubQueryRange<T>
Extension methods for all ordered subqueries.
ProjectedOrderedQuery1 on ProjectedOrderedQuery<(Expr<A>)>
Extension methods for a query returning zero or more rows with 1 expression.
ProjectedOrderedQuery2 on ProjectedOrderedQuery<(Expr<A>, Expr<B>)>
Extension methods for a query returning zero or more rows with 2 expressions.
ProjectedOrderedQuery3 on ProjectedOrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a query returning zero or more rows with 3 expressions.
ProjectedOrderedQuery4 on ProjectedOrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a query returning zero or more rows with 4 expressions.
ProjectedOrderedQuery5 on ProjectedOrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a query returning zero or more rows with 5 expressions.
ProjectedOrderedQuery6 on ProjectedOrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a query returning zero or more rows with 6 expressions.
ProjectedOrderedQuery7 on ProjectedOrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a query returning zero or more rows with 7 expressions.
ProjectedOrderedQuery8 on ProjectedOrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a query returning zero or more rows with 8 expressions.
ProjectedOrderedQueryExt on ProjectedOrderedQuery<T>
Extension methods for all ordered queries.
ProjectedOrderedQueryRange1 on ProjectedOrderedQueryRange<(Expr<A>)>
Extension methods for a query returning zero or more rows with 1 expression.
ProjectedOrderedQueryRange2 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>
Extension methods for a query returning zero or more rows with 2 expressions.
ProjectedOrderedQueryRange3 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a query returning zero or more rows with 3 expressions.
ProjectedOrderedQueryRange4 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a query returning zero or more rows with 4 expressions.
ProjectedOrderedQueryRange5 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a query returning zero or more rows with 5 expressions.
ProjectedOrderedQueryRange6 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a query returning zero or more rows with 6 expressions.
ProjectedOrderedQueryRange7 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a query returning zero or more rows with 7 expressions.
ProjectedOrderedQueryRange8 on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a query returning zero or more rows with 8 expressions.
ProjectedOrderedQueryRangeExt on ProjectedOrderedQueryRange<T>
Extension methods for all ordered queries.
ProjectedOrderedSubQuery1 on ProjectedOrderedSubQuery<(Expr<A>)>
Extension methods for a ordered subquery of zero or more rows with 1 expression.
ProjectedOrderedSubQuery1Ext on ProjectedOrderedSubQuery<(Expr<T>)>
Extension methods for subqueries projected to a single expression.
ProjectedOrderedSubQuery2 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>)>
Extension methods for a ordered subquery of zero or more rows with 2 expressions.
ProjectedOrderedSubQuery3 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a ordered subquery of zero or more rows with 3 expressions.
ProjectedOrderedSubQuery4 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a ordered subquery of zero or more rows with 4 expressions.
ProjectedOrderedSubQuery5 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a ordered subquery of zero or more rows with 5 expressions.
ProjectedOrderedSubQuery6 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a ordered subquery of zero or more rows with 6 expressions.
ProjectedOrderedSubQuery7 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a ordered subquery of zero or more rows with 7 expressions.
ProjectedOrderedSubQuery8 on ProjectedOrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a ordered subquery of zero or more rows with 8 expressions.
ProjectedOrderedSubQueryExt on ProjectedOrderedSubQuery<T>
Extension methods for all ordered subqueries.
ProjectedOrderedSubQueryRange1 on ProjectedOrderedSubQueryRange<(Expr<A>)>
Extension methods for a ordered subquery of zero or more rows with 1 expression.
ProjectedOrderedSubQueryRange1Ext on ProjectedOrderedSubQueryRange<(Expr<T>)>
Extension methods for subqueries projected to a single expression.
ProjectedOrderedSubQueryRange2 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>)>
Extension methods for a ordered subquery of zero or more rows with 2 expressions.
ProjectedOrderedSubQueryRange3 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a ordered subquery of zero or more rows with 3 expressions.
ProjectedOrderedSubQueryRange4 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a ordered subquery of zero or more rows with 4 expressions.
ProjectedOrderedSubQueryRange5 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a ordered subquery of zero or more rows with 5 expressions.
ProjectedOrderedSubQueryRange6 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a ordered subquery of zero or more rows with 6 expressions.
ProjectedOrderedSubQueryRange7 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a ordered subquery of zero or more rows with 7 expressions.
ProjectedOrderedSubQueryRange8 on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a ordered subquery of zero or more rows with 8 expressions.
ProjectedOrderedSubQueryRangeExt on ProjectedOrderedSubQueryRange<T>
Extension methods for all ordered subqueries.
Query1 on Query<(Expr<A>)>
Extension methods for a query returning zero or more rows with 1 expression.
Query2 on Query<(Expr<A>, Expr<B>)>
Extension methods for a query returning zero or more rows with 2 expressions.
Query3 on Query<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a query returning zero or more rows with 3 expressions.
Query4 on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a query returning zero or more rows with 4 expressions.
Query5 on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a query returning zero or more rows with 5 expressions.
Query6 on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a query returning zero or more rows with 6 expressions.
Query7 on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a query returning zero or more rows with 7 expressions.
Query8 on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a query returning zero or more rows with 8 expressions.
QueryDateTime on Query<(Expr<DateTime?>)>
Extension methods for queries projected to a DateTime expression.
QueryExt on Query<T>
Extension methods for all queries.
QueryInteger on Query<(Expr<int?>)>
Extension methods for queries projected to an int expression.
QueryReal on Query<(Expr<double?>)>
Extension methods for queries projected to a double expression.
QuerySingle1 on QuerySingle<(Expr<A>)>
Extensions for a query returning at-most one row with 1 expression.
QuerySingle1AsExpr on QuerySingle<(Expr<T>)>
Extension methods for queries projected to a single expression.
QuerySingle2 on QuerySingle<(Expr<A>, Expr<B>)>
Extensions for a query returning at-most one row with 2 expressions.
QuerySingle3 on QuerySingle<(Expr<A>, Expr<B>, Expr<C>)>
Extensions for a query returning at-most one row with 3 expressions.
QuerySingle4 on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extensions for a query returning at-most one row with 4 expressions.
QuerySingle5 on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extensions for a query returning at-most one row with 5 expressions.
QuerySingle6 on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extensions for a query returning at-most one row with 6 expressions.
QuerySingle7 on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extensions for a query returning at-most one row with 7 expressions.
QuerySingle8 on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extensions for a query returning at-most one row with 8 expressions.
QueryString on Query<(Expr<String?>)>
Extension methods for queries projected to a String expression.
QuerySubExt on SubQuery<T>
Extension methods for all subqueries.
Return1 on Return<(Expr<A>)>
Extension methods for a statement returning zero or more rows with 1 expression.
Return2 on Return<(Expr<A>, Expr<B>)>
Extension methods for a statement returning zero or more rows with 2 expressions.
Return3 on Return<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a statement returning zero or more rows with 3 expressions.
Return4 on Return<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a statement returning zero or more rows with 4 expressions.
Return5 on Return<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a statement returning zero or more rows with 5 expressions.
Return6 on Return<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a statement returning zero or more rows with 6 expressions.
Return7 on Return<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a statement returning zero or more rows with 7 expressions.
Return8 on Return<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a statement returning zero or more rows with 8 expressions.
ReturnOne1 on ReturnOne<(Expr<A>)>
Extension methods for a statement returning exactly one row with 1 expression.
ReturnOne2 on ReturnOne<(Expr<A>, Expr<B>)>
Extension methods for a statement returning exactly one row with 2 expressions.
ReturnOne3 on ReturnOne<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a statement returning exactly one row with 3 expressions.
ReturnOne4 on ReturnOne<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a statement returning exactly one row with 4 expressions.
ReturnOne5 on ReturnOne<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a statement returning exactly one row with 5 expressions.
ReturnOne6 on ReturnOne<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a statement returning exactly one row with 6 expressions.
ReturnOne7 on ReturnOne<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a statement returning exactly one row with 7 expressions.
ReturnOne8 on ReturnOne<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a statement returning exactly one row with 8 expressions.
ReturnSingle1 on ReturnSingle<(Expr<A>)>
Extension methods for a statement returning at-most one row with 1 expression.
ReturnSingle2 on ReturnSingle<(Expr<A>, Expr<B>)>
Extension methods for a statement returning at-most one row with 2 expressions.
ReturnSingle3 on ReturnSingle<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a statement returning at-most one row with 3 expressions.
ReturnSingle4 on ReturnSingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a statement returning at-most one row with 4 expressions.
ReturnSingle5 on ReturnSingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a statement returning at-most one row with 5 expressions.
ReturnSingle6 on ReturnSingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a statement returning at-most one row with 6 expressions.
ReturnSingle7 on ReturnSingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a statement returning at-most one row with 7 expressions.
ReturnSingle8 on ReturnSingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a statement returning at-most one row with 8 expressions.
RightJoin1On1 on RightJoin<(Expr<A>), (Expr<B>)>
Extension methods for completing an RIGHT JOIN.
RightJoin1On2 on RightJoin<(Expr<A>), (Expr<B>, Expr<C>)>
Extension methods for completing an RIGHT JOIN.
RightJoin1On3 on RightJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>)>
Extension methods for completing an RIGHT JOIN.
RightJoin1On4 on RightJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing an RIGHT JOIN.
RightJoin1On5 on RightJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an RIGHT JOIN.
RightJoin1On6 on RightJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an RIGHT JOIN.
RightJoin1On7 on RightJoin<(Expr<A>), (Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an RIGHT JOIN.
RightJoin2On1 on RightJoin<(Expr<A>, Expr<B>), (Expr<C>)>
Extension methods for completing an RIGHT JOIN.
RightJoin2On2 on RightJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>)>
Extension methods for completing an RIGHT JOIN.
RightJoin2On3 on RightJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>)>
Extension methods for completing an RIGHT JOIN.
RightJoin2On4 on RightJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an RIGHT JOIN.
RightJoin2On5 on RightJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an RIGHT JOIN.
RightJoin2On6 on RightJoin<(Expr<A>, Expr<B>), (Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an RIGHT JOIN.
RightJoin3On1 on RightJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>)>
Extension methods for completing an RIGHT JOIN.
RightJoin3On2 on RightJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>)>
Extension methods for completing an RIGHT JOIN.
RightJoin3On3 on RightJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>)>
Extension methods for completing an RIGHT JOIN.
RightJoin3On4 on RightJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an RIGHT JOIN.
RightJoin3On5 on RightJoin<(Expr<A>, Expr<B>, Expr<C>), (Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an RIGHT JOIN.
RightJoin4On1 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>)>
Extension methods for completing an RIGHT JOIN.
RightJoin4On2 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>)>
Extension methods for completing an RIGHT JOIN.
RightJoin4On3 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>)>
Extension methods for completing an RIGHT JOIN.
RightJoin4On4 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), (Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an RIGHT JOIN.
RightJoin5On1 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>)>
Extension methods for completing an RIGHT JOIN.
RightJoin5On2 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>)>
Extension methods for completing an RIGHT JOIN.
RightJoin5On3 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>), (Expr<F>, Expr<G>, Expr<H>)>
Extension methods for completing an RIGHT JOIN.
RightJoin6On1 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>)>
Extension methods for completing an RIGHT JOIN.
RightJoin6On2 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>), (Expr<G>, Expr<H>)>
Extension methods for completing an RIGHT JOIN.
RightJoin7On1 on RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>), (Expr<H>)>
Extension methods for completing an RIGHT JOIN.
StringExt on T
Extension methods for wrapping a String as an expression.
SubQuery1 on SubQuery<(Expr<A>)>
Extension methods for a subquery returning zero or more rows with 1 expression.
SubQuery1Ext on SubQuery<(Expr<T>)>
Extension methods for subqueries projected to a single expression.
SubQuery2 on SubQuery<(Expr<A>, Expr<B>)>
Extension methods for a subquery returning zero or more rows with 2 expressions.
SubQuery3 on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>
Extension methods for a subquery returning zero or more rows with 3 expressions.
SubQuery4 on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>
Extension methods for a subquery returning zero or more rows with 4 expressions.
SubQuery5 on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>
Extension methods for a subquery returning zero or more rows with 5 expressions.
SubQuery6 on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>
Extension methods for a subquery returning zero or more rows with 6 expressions.
SubQuery7 on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>
Extension methods for a subquery returning zero or more rows with 7 expressions.
SubQuery8 on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>
Extension methods for a subquery returning zero or more rows with 8 expressions.
SubQueryDateTime on SubQuery<(Expr<DateTime?>)>
Extension methods for subqueries projected to a DateTime expression.
SubQueryInteger on SubQuery<(Expr<int?>)>
Extension methods for subqueries projected to an int expression.
SubQueryReal on SubQuery<(Expr<double?>)>
Extension methods for subqueries projected to a double expression.
SubQueryString on SubQuery<(Expr<String?>)>
Extension methods for subqueries projected to a String expression.
Uint8ListExt on T
Extension methods for wrapping an Uint8List as an expression.

Functions

toExpr<T extends Object?>(T value) Expr<T> Inserting rows Writing queries Update and delete
Create an Expr<T> wrapping value.

Exceptions / Errors

AuthenticationException Exceptions
Thrown when authentication with the database failed.
ConstraintViolationException Exceptions
Thrown when an operation was aborted because a constraint violation in the database.
DatabaseConnectionBrokenException Exceptions
Thrown when the database connection was broken.
DatabaseConnectionException Exceptions
Thrown when there is an issue with the database connection.
DatabaseConnectionForceClosedException Exceptions
Thrown when the database connection is force closed.
DatabaseConnectionRefusedException Exceptions
Thrown when the database connection was refused.
DatabaseConnectionTimeoutException Exceptions
Thrown when a connection timeout happened.
DatabaseException Exceptions
Base class for all exceptions thrown by package:typed_sql.
DivisionByZeroException Exceptions
Thrown when a division by zero happened in the database.
IntermittentConnectionException Exceptions
Thrown when there is an intermittent issue with the database connection.
OperationException Exceptions
Thrown when the database reports an error while executing an operation.
TransactionAbortedException Exceptions
Thrown when a transaction was rolled back.
TypeCastException Exceptions
Thrown when an SQL type cast fail in the database.
UnspecifiedOperationException Exceptions
An unspecified OperationException.