Type parameters
Constructors
constructor
• new RelationalQuery<Expr>(expression)
Type parameters
Parameters
Properties
expressionType
•Readonly expressionType: Expr
expression
•Readonly expression: QueryExpression
Methods
as
▸ as<Name>(alias): RelationalQuery<Alias<Expr, Name>>
Type parameters
Parameters
Returns
RelationalQuery<Alias<Expr, Name>>
filter
▸ filter<Predicate>(predicate): RelationalQuery<Filter<Expr, Predicate>>
Type parameters
Parameters
Returns
RelationalQuery<Filter<Expr, Predicate>>
select
▸ select<Fields>(fields): RelationalQuery<Select<Expr, Fields>>
Type parameters
Parameters
Returns
RelationalQuery<Select<Expr, Fields>>
leftJoin
▸ leftJoin<Right, Options>(right, options): RelationalQuery<Join<Expr, Right, "left", Options>>
Type parameters
Parameters
Returns
RelationalQuery<Join<Expr, Right, "left", Options>>
innerJoin
▸ innerJoin<Right, Options>(right, options): RelationalQuery<Join<Expr, Right, "inner", Options>>
Type parameters
Parameters
Returns
RelationalQuery<Join<Expr, Right, "inner", Options>>
aggregate
▸ aggregate<Name, From, Aggregates>(alias, options): RelationalQuery<Aggregate<Expr, Name, From, Aggregates>>
Type parameters
Parameters
Returns
RelationalQuery<Aggregate<Expr, Name, From, Aggregates>>
groupBy
▸ groupBy<Fields>(fields, window?): Object
Type parameters
Parameters
Returns
Object
orderBy
▸ orderBy(keys): RelationalQuery<Sort<Expr>>
Parameters
Returns
RelationalQuery<Sort<Expr>>
limit
▸ limit(rows): RelationalQuery<Sort<Expr>>
Parameters
Returns
RelationalQuery<Sort<Expr>>