Class: RdbmsFunctionBuilder

Defined in: src/rdbms/functions.ts:26

Cross-dialect database functions builder providing typed SQL expressions.

Constructors

Constructor

new RdbmsFunctionBuilder(): RdbmsFunctionBuilder

Returns

RdbmsFunctionBuilder

Methods

lower()

lower(col): SqlFragment

Defined in: src/rdbms/functions.ts:29

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

upper()

upper(col): SqlFragment

Defined in: src/rdbms/functions.ts:33

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

trim()

trim(col): SqlFragment

Defined in: src/rdbms/functions.ts:37

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

length()

length(col): SqlFragment

Defined in: src/rdbms/functions.ts:41

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

concat()

concat(...items): SqlFragment

Defined in: src/rdbms/functions.ts:45

Parameters

Parameter	Type
...items	unknown[]

Returns

SqlFragment

---

substring()

substring(col, start, length?): SqlFragment

Defined in: src/rdbms/functions.ts:49

Parameters

Parameter	Type
col	unknown
start	number
length?	number

Returns

SqlFragment

---

replace()

replace(col, search, replacement): SqlFragment

Defined in: src/rdbms/functions.ts:56

Parameters

Parameter	Type
col	unknown
search	string
replacement	string

Returns

SqlFragment

---

abs()

abs(val): SqlFragment

Defined in: src/rdbms/functions.ts:62

Parameters

Parameter	Type
val	unknown

Returns

SqlFragment

---

round()

round(val, decimals?): SqlFragment

Defined in: src/rdbms/functions.ts:66

Parameters

Parameter	Type	Default value
val	unknown	undefined
decimals	number	0

Returns

SqlFragment

---

ceil()

ceil(val): SqlFragment

Defined in: src/rdbms/functions.ts:71

Parameters

Parameter	Type
val	unknown

Returns

SqlFragment

---

floor()

floor(val): SqlFragment

Defined in: src/rdbms/functions.ts:75

Parameters

Parameter	Type
val	unknown

Returns

SqlFragment

---

power()

power(base, exp): SqlFragment

Defined in: src/rdbms/functions.ts:79

Parameters

Parameter	Type
base	unknown
exp	unknown

Returns

SqlFragment

---

sqrt()

sqrt(val): SqlFragment

Defined in: src/rdbms/functions.ts:83

Parameters

Parameter	Type
val	unknown

Returns

SqlFragment

---

now()

now(): SqlFragment

Defined in: src/rdbms/functions.ts:89

Returns

SqlFragment

---

currentDate()

currentDate(): SqlFragment

Defined in: src/rdbms/functions.ts:93

Returns

SqlFragment

---

currentTime()

currentTime(): SqlFragment

Defined in: src/rdbms/functions.ts:97

Returns

SqlFragment

---

coalesce()

coalesce(...items): SqlFragment

Defined in: src/rdbms/functions.ts:103

Parameters

Parameter	Type
...items	unknown[]

Returns

SqlFragment

---

nullif()

nullif(val1, val2): SqlFragment

Defined in: src/rdbms/functions.ts:107

Parameters

Parameter	Type
val1	unknown
val2	unknown

Returns

SqlFragment

---

count()

count(col?): SqlFragment

Defined in: src/rdbms/functions.ts:111

Parameters

Parameter	Type	Default value
col	unknown	'*'

Returns

SqlFragment

---

sum()

sum(col): SqlFragment

Defined in: src/rdbms/functions.ts:115

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

avg()

avg(col): SqlFragment

Defined in: src/rdbms/functions.ts:119

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

min()

min(col): SqlFragment

Defined in: src/rdbms/functions.ts:123

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment

---

max()

max(col): SqlFragment

Defined in: src/rdbms/functions.ts:127

Parameters

Parameter	Type
col	unknown

Returns

SqlFragment