Class SelectStatement

Hierarchy

NodeExpression
default
- SelectStatement

Constructors

constructor

new SelectStatement(cores?): SelectStatement
Parameters
- cores: SelectCore[] = ...
Returns SelectStatement
Overrides NodeExpression.constructor
- Defined in src/nodes/SelectStatement.ts:19

Properties

`Readonly` cores

cores: SelectCore[]

limit

limit: any = null

lock

lock: any = null

offset

offset: any = null

orders

orders: any[] = []

with

with: any = null

Methods

add

add(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.add
- Defined in src/mixins/Math.ts:14

and

and(right): And
Parameters
- right: any
Returns And
Inherited from NodeExpression.and
- Defined in src/mixins/NodeMethods.ts:11

as

as(other): As
Parameters
- other: string | SQLLiteral
Returns As
- Defined in src/mixins/AliasPredication.ts:5

bitwiseAnd

bitwiseAnd(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.bitwiseAnd
- Defined in src/mixins/Math.ts:18

bitwiseNot

bitwiseNot(): BitwiseNot
Returns BitwiseNot
Inherited from NodeExpression.bitwiseNot
- Defined in src/mixins/Math.ts:22

bitwiseOr

bitwiseOr(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.bitwiseOr
- Defined in src/mixins/Math.ts:26

bitwiseShiftLeft

bitwiseShiftLeft(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.bitwiseShiftLeft
- Defined in src/mixins/Math.ts:30

bitwiseShiftRight

bitwiseShiftRight(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.bitwiseShiftRight
- Defined in src/mixins/Math.ts:34

bitwiseXor

bitwiseXor(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.bitwiseXor
- Defined in src/mixins/Math.ts:38

coalesce

coalesce(...exprs): NamedSQLFunction
Parameters
- Rest ...exprs: any[]
Returns NamedSQLFunction
Inherited from NodeExpression.coalesce
- Defined in src/mixins/FactoryMethods.ts:22

concat

concat(other): Concat
Parameters
- other: any
Returns Concat
Inherited from NodeExpression.concat
- Defined in src/mixins/ConcatPredication.ts:4

count

count(distinct?): Count
Parameters
- distinct: boolean = false
Returns Count
Inherited from NodeExpression.count
- Defined in src/mixins/Expressions.ts:13

createAnd

createAnd(clauses): And
Parameters
- clauses: any[]
Returns And
Inherited from NodeExpression.createAnd
- Defined in src/mixins/FactoryMethods.ts:26

createFalse

createFalse(): False
Returns False
Inherited from NodeExpression.createFalse
- Defined in src/mixins/FactoryMethods.ts:30

createJoin

createJoin(to): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
Returns InnerJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:34
createJoin(to, constraint): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
Returns InnerJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:35
createJoin(to, constraint, Klass): FullOuterJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof FullOuterJoin
Returns FullOuterJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:39
createJoin(to, constraint, Klass): InnerJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof InnerJoin
Returns InnerJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:44
createJoin(to, constraint, Klass): OuterJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof OuterJoin
Returns OuterJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:49
createJoin(to, constraint, Klass): RightOuterJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof RightOuterJoin
Returns RightOuterJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:54
createJoin(to, constraint, Klass): StringJoin
Parameters
- to: null | string | SQLLiteral | Relation
- constraint: any
- Klass: typeof StringJoin
Returns StringJoin
Inherited from NodeExpression.createJoin
- Defined in src/mixins/FactoryMethods.ts:59

createOn

createOn(expr): On
Parameters
- expr: any
Returns On
Inherited from NodeExpression.createOn
- Defined in src/mixins/FactoryMethods.ts:72

createStringJoin

createStringJoin(to): StringJoin
Parameters
- to: null | string | SQLLiteral | Relation
Returns StringJoin
Inherited from NodeExpression.createStringJoin
- Defined in src/mixins/FactoryMethods.ts:76

createTableAlias

createTableAlias(relation, name): TableAlias
Parameters
- relation: Relation | Grouping
- name: string | SQLLiteral
Returns TableAlias
Inherited from NodeExpression.createTableAlias
- Defined in src/mixins/FactoryMethods.ts:80

createTrue

createTrue(): True
Returns True
Inherited from NodeExpression.createTrue
- Defined in src/mixins/FactoryMethods.ts:87

desc

desc(this): Descending
Parameters
- this: Visitable
Returns Descending
Inherited from NodeExpression.desc
- Defined in src/mixins/OrderPredications.ts:11

divide

divide(other): Division
Parameters
- other: any
Returns Division
Inherited from NodeExpression.divide
- Defined in src/mixins/Math.ts:42

doesNotMatch

doesNotMatch(other, escape?, caseSensitive?): DoesNotMatch
Parameters
- other: any
- escape: any = null
- caseSensitive: boolean = false
Returns DoesNotMatch
Inherited from NodeExpression.doesNotMatch
- Defined in src/mixins/Predications.ts:57

doesNotMatchAll

doesNotMatchAll(others, escape?, caseSensitive?): Grouping
Parameters
- others: any
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from NodeExpression.doesNotMatchAll
- Defined in src/mixins/Predications.ts:65

doesNotMatchAny

doesNotMatchAny(others, escape?, caseSensitive?): Grouping
Parameters
- others: any
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from NodeExpression.doesNotMatchAny
- Defined in src/mixins/Predications.ts:78

doesNotMatchRegexp

doesNotMatchRegexp(other, caseSensitive?): NotRegexp
Parameters
- other: any
- caseSensitive: boolean = true
Returns NotRegexp
Inherited from NodeExpression.doesNotMatchRegexp
- Defined in src/mixins/Predications.ts:91

eq

eq(other): Equality<any, any>
Parameters
- other: any
Returns Equality<any, any>
Inherited from NodeExpression.eq
- Defined in src/mixins/Predications.ts:95

eqAll

eqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.eqAll
- Defined in src/mixins/Predications.ts:99

eqAny

eqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.eqAny
- Defined in src/mixins/Predications.ts:103

extract

extract(field): Extract
Parameters
- field: any
Returns Extract
Inherited from NodeExpression.extract
- Defined in src/mixins/Expressions.ts:17

grouping

grouping(expr): Grouping
Parameters
- expr: any
Returns Grouping
Inherited from NodeExpression.grouping
- Defined in src/mixins/FactoryMethods.ts:91

`Protected` groupingAll

groupingAll(method, others, ...extras): Grouping
Parameters
- method: ((expr, ...extras) => any)
  - - (expr, ...extras): any
    - Parameters
      
      expr: any
      
      Rest ...extras: any[]
      
      Returns any
- others: any[]
- Rest ...extras: any[]
Returns Grouping
Inherited from NodeExpression.groupingAll
- Defined in src/mixins/Predications.ts:25

`Protected` groupingAny

groupingAny(method, others, ...extras): Grouping
Parameters
- method: ((expr, ...extras) => any)
  - - (expr, ...extras): any
    - Parameters
      
      expr: any
      
      Rest ...extras: any[]
      
      Returns any
- others: any[]
- Rest ...extras: any[]
Returns Grouping
Inherited from NodeExpression.groupingAny
- Defined in src/mixins/Predications.ts:35

gt

gt(other): GreaterThan
Parameters
- other: any
Returns GreaterThan
Inherited from NodeExpression.gt
- Defined in src/mixins/Predications.ts:107

gtAll

gtAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.gtAll
- Defined in src/mixins/Predications.ts:111

gtAny

gtAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.gtAny
- Defined in src/mixins/Predications.ts:115

gteq

gteq(other): GreaterThanOrEqual
Parameters
- other: any
Returns GreaterThanOrEqual
Inherited from NodeExpression.gteq
- Defined in src/mixins/Predications.ts:119

gteqAll

gteqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.gteqAll
- Defined in src/mixins/Predications.ts:123

gteqAny

gteqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.gteqAny
- Defined in src/mixins/Predications.ts:127

inAll

inAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.inAll
- Defined in src/mixins/Predications.ts:143

inAny

inAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.inAny
- Defined in src/mixins/Predications.ts:147

inVal

inVal(other): In
Parameters
- other: any
Returns In
Inherited from NodeExpression.inVal
- Defined in src/mixins/Predications.ts:131

isDistinctFrom

isDistinctFrom(other): IsDistinctFrom
Parameters
- other: any
Returns IsDistinctFrom
Inherited from NodeExpression.isDistinctFrom
- Defined in src/mixins/Predications.ts:155

`Protected` isInfinity

isInfinity(value): boolean
Parameters
- value: any
Returns boolean
Inherited from NodeExpression.isInfinity
- Defined in src/mixins/Predications.ts:45

isNotDistinctFrom

isNotDistinctFrom(other): IsNotDistinctFrom
Parameters
- other: any
Returns IsNotDistinctFrom
Inherited from NodeExpression.isNotDistinctFrom
- Defined in src/mixins/Predications.ts:151

`Protected` isOpenEnded

isOpenEnded(value): boolean
Parameters
- value: any
Returns boolean
Inherited from NodeExpression.isOpenEnded
- Defined in src/mixins/Predications.ts:49

`Protected` isUnboundable

isUnboundable(value): boolean
Parameters
- value: any
Returns boolean
Inherited from NodeExpression.isUnboundable
- Defined in src/mixins/Predications.ts:53

lower

lower(column): NamedSQLFunction
Parameters
- column: any
Returns NamedSQLFunction
Inherited from NodeExpression.lower
- Defined in src/mixins/FactoryMethods.ts:95

lt

lt(other): LessThan
Parameters
- other: any
Returns LessThan
Inherited from NodeExpression.lt
- Defined in src/mixins/Predications.ts:159

ltAll

ltAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.ltAll
- Defined in src/mixins/Predications.ts:163

ltAny

ltAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.ltAny
- Defined in src/mixins/Predications.ts:167

lteq

lteq(other): LessThanOrEqual
Parameters
- other: any
Returns LessThanOrEqual
Inherited from NodeExpression.lteq
- Defined in src/mixins/Predications.ts:171

lteqAll

lteqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.lteqAll
- Defined in src/mixins/Predications.ts:175

lteqAny

lteqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.lteqAny
- Defined in src/mixins/Predications.ts:179

matches

matches(other, escape?, caseSensitive?): Matches
Parameters
- other: any
- escape: any = null
- caseSensitive: boolean = false
Returns Matches
Inherited from NodeExpression.matches
- Defined in src/mixins/Predications.ts:183

matchesAll

matchesAll(others, escape?, caseSensitive?): Grouping
Parameters
- others: any[]
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from NodeExpression.matchesAll
- Defined in src/mixins/Predications.ts:187

matchesAny

matchesAny(others, escape?, caseSensitive?): Grouping
Parameters
- others: any[]
- escape: any = null
- caseSensitive: boolean = false
Returns Grouping
Inherited from NodeExpression.matchesAny
- Defined in src/mixins/Predications.ts:200

matchesRegexp

matchesRegexp(other, caseSensitive?): Regexp
Parameters
- other: any
- caseSensitive: boolean = true
Returns Regexp
Inherited from NodeExpression.matchesRegexp
- Defined in src/mixins/Predications.ts:213

maximum

maximum(): Max
Returns Max
Inherited from NodeExpression.maximum
- Defined in src/mixins/Expressions.ts:21

minimum

minimum(): Min
Returns Min
Inherited from NodeExpression.minimum
- Defined in src/mixins/Expressions.ts:25

multiply

multiply(other): Multiplication
Parameters
- other: any
Returns Multiplication
Inherited from NodeExpression.multiply
- Defined in src/mixins/Math.ts:46

not

not(this): Not
Parameters
- this: Node
Returns Not
Inherited from NodeExpression.not
- Defined in src/mixins/NodeMethods.ts:15

notBetween

notBetween(begin, end, inclusive?): Grouping | In | GreaterThan | GreaterThanOrEqual | LessThan
Parameters
- begin: number | BindParam | Quoted
- end: number | BindParam | Quoted
- inclusive: boolean = true
Returns Grouping | In | GreaterThan | GreaterThanOrEqual | LessThan
Inherited from NodeExpression.notBetween
- Defined in src/mixins/Predications.ts:292

notEq

notEq(other): NotEqual
Parameters
- other: any
Returns NotEqual
Inherited from NodeExpression.notEq
- Defined in src/mixins/Predications.ts:217

notEqAll

notEqAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.notEqAll
- Defined in src/mixins/Predications.ts:221

notEqAny

notEqAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.notEqAny
- Defined in src/mixins/Predications.ts:225

notInAll

notInAll(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.notInAll
- Defined in src/mixins/Predications.ts:241

notInAny

notInAny(others): Grouping
Parameters
- others: any[]
Returns Grouping
Inherited from NodeExpression.notInAny
- Defined in src/mixins/Predications.ts:245

notInVal

notInVal(other): NotIn
Parameters
- other: any
Returns NotIn
Inherited from NodeExpression.notInVal
- Defined in src/mixins/Predications.ts:229

or

or<T>(right): Grouping
Type Parameters
- T extends Visitable
Parameters
- right: T
Returns Grouping
Inherited from NodeExpression.or
- Defined in src/mixins/NodeMethods.ts:19

quotedArray

quotedArray(others): any[]
Parameters
- others: any[]
Returns any[]
Inherited from NodeExpression.quotedArray
- Defined in src/mixins/Predications.ts:253

quotedNode

quotedNode(other): any
Parameters
- other: any
Returns any
Inherited from NodeExpression.quotedNode
- Defined in src/mixins/Predications.ts:249

subtract

subtract(other): Grouping
Parameters
- other: any
Returns Grouping
Inherited from NodeExpression.subtract
- Defined in src/mixins/Math.ts:50

sum

sum(): Sum
Returns Sum
Inherited from NodeExpression.sum
- Defined in src/mixins/Expressions.ts:29

toSQL

toSQL(engine?): any
Parameters
- engine: undefined | null | Engine = undefined
Returns any
Inherited from NodeExpression.toSQL
- Defined in src/nodes/Node.ts:16

when

when(other): Case
Parameters
- other: any
Returns Case
Inherited from NodeExpression.when
- Defined in src/mixins/WhenPredication.ts:5

Class SelectStatement

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

cores: SelectCore[] = ...

Returns SelectStatement

Properties

Readonly cores

limit

lock

offset

orders

with

Methods

add

Parameters

other: any

Returns Grouping

and

Parameters

right: any

Returns And

as

Parameters

other: string | SQLLiteral

Returns As

asc

Parameters

this: Visitable

Returns Ascending

average

Returns Avg

between

Parameters

begin: number | BindParam | Quoted

end: number | BindParam | Quoted

inclusive: boolean = true

Returns Between | GreaterThanOrEqual | LessThan | LessThanOrEqual | NotIn | And

bitwiseAnd

Parameters

other: any

Returns Grouping

bitwiseNot

Returns BitwiseNot

bitwiseOr

Parameters

other: any

Returns Grouping

bitwiseShiftLeft

Parameters

other: any

Returns Grouping

bitwiseShiftRight

Parameters

other: any

Returns Grouping

bitwiseXor

Parameters

other: any

Returns Grouping

coalesce

Parameters

Rest ...exprs: any[]

Returns NamedSQLFunction

concat

Parameters

other: any

Returns Concat

count

Parameters

distinct: boolean = false

Returns Count

createAnd

Parameters

clauses: any[]

`Readonly` cores

`Rest` ...exprs: any[]