Class Expr

Index

Methods

add alias and as asc between cast desc div eq free gt gte ilike inList is isNotNull isNull like lt lte mod mul neg neq not notIn or rlike sub toJSON toSql xor

Methods

add

add(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:62

alias

alias(name: string): Expr
Parameters
- name: string
Returns Expr
- Defined in builders.ts:107

and

and(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:50

as

as(name: string): Expr
Parameters
- name: string
Returns Expr
- Defined in builders.ts:110

asc

asc(): Expr
Returns Expr
- Defined in builders.ts:116

between

between(low: ExprInput, high: ExprInput): Expr
Parameters
- low: ExprInput
- high: ExprInput
Returns Expr
- Defined in builders.ts:98

cast

cast(to: string): Expr
Parameters
- to: string
Returns Expr
- Defined in builders.ts:113

desc

desc(): Expr
Returns Expr
- Defined in builders.ts:119

div

div(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:71

eq

eq(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:32

free

free(): void
Returns void
- Defined in builders.ts:128

gt

gt(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:44

gte

gte(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:47

ilike

ilike(pattern: ExprInput): Expr
Parameters
- pattern: ExprInput
Returns Expr
- Defined in builders.ts:86

inList

inList(...values: ExprInput[]): Expr
Parameters
- ...values: ExprInput[]
Returns Expr
- Defined in builders.ts:101

is

is(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:80

isNotNull

isNotNull(): Expr
Returns Expr
- Defined in builders.ts:95

isNull

isNull(): Expr
Returns Expr
- Defined in builders.ts:92

like

like(pattern: ExprInput): Expr
Parameters
- pattern: ExprInput
Returns Expr
- Defined in builders.ts:83

lt

lt(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:38

lte

lte(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:41

mod

mod(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:74

mul

mul(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:68

neg

neg(): Expr
Returns Expr
- Defined in builders.ts:77

neq

neq(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:35

not

not(): Expr
Returns Expr
- Defined in builders.ts:59

notIn

notIn(...values: ExprInput[]): Expr
Parameters
- ...values: ExprInput[]
Returns Expr
- Defined in builders.ts:104

or

or(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:53

rlike

rlike(pattern: ExprInput): Expr
Parameters
- pattern: ExprInput
Returns Expr
- Defined in builders.ts:89

sub

sub(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:65

toJSON

toJSON(): unknown
Returns unknown
- Defined in builders.ts:125

toSql

toSql(dialect?: string): string
Parameters
- dialect: string = 'generic'
Returns string
- Defined in builders.ts:122

xor

xor(other: ExprInput): Expr
Parameters
- other: ExprInput
Returns Expr
- Defined in builders.ts:56