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:4303

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:4307

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:4319

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:4311

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:4323

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:4299

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:4327

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:4315

Generated using TypeDoc