Interface QueryBuilder

QueryBuilder builds different clauses for a SELECT SQL statement.

Hierarchy

QueryBuilder

Indexable

[key: string]: any

Index

Methods

buildFrom buildGroupBy buildHaving buildJoin buildOrderByAndLimit buildSelect buildUnion buildWhere

Methods

buildFrom

buildFrom(tables): string
BuildFrom generates a FROM clause from the given tables.
Parameters
- tables: string[]
Returns string
- Defined in types.d.ts:4430

buildGroupBy

buildGroupBy(cols): string
BuildGroupBy generates a GROUP BY clause from the given group-by columns.
Parameters
- cols: string[]
Returns string
- Defined in types.d.ts:4434

buildHaving

buildHaving(_arg0, _arg1): string
BuildHaving generates a HAVING clause from the given expression.
Parameters
- _arg0: Expression
- _arg1: Params
Returns string
- Defined in types.d.ts:4446

buildJoin

buildJoin(_arg0, _arg1): string
BuildJoin generates a JOIN clause from the given join information.
Parameters
- _arg0: JoinInfo[]
- _arg1: Params
Returns string
- Defined in types.d.ts:4438

buildOrderByAndLimit

buildOrderByAndLimit(_arg0, _arg1, _arg2, _arg3): string
BuildOrderByAndLimit generates the ORDER BY and LIMIT clauses.
Parameters
- _arg0: string
- _arg1: string[]
- _arg2: number
- _arg3: number
Returns string
- Defined in types.d.ts:4450

buildSelect

buildSelect(cols, distinct, option): string
BuildSelect generates a SELECT clause from the given selected column names.
Parameters
- cols: string[]
- distinct: boolean
- option: string
Returns string
- Defined in types.d.ts:4426

buildUnion

buildUnion(_arg0, _arg1): string
BuildUnion generates a UNION clause from the given union information.
Parameters
- _arg0: UnionInfo[]
- _arg1: Params
Returns string
- Defined in types.d.ts:4454

buildWhere

buildWhere(_arg0, _arg1): string
BuildWhere generates a WHERE clause from the given expression.
Parameters
- _arg0: Expression
- _arg1: Params
Returns string
- Defined in types.d.ts:4442

Generated using TypeDoc