Class SimpleCaseBuilder

Fluent builder for a "simple" CASE expression: CASE expr WHEN val1 THEN result1 WHEN val2 THEN result2 ... ELSE else END

Build with caseOf(expr). Terminate with .as(alias) or .toSQL() / .toLiteral().

Index

Constructors

Methods

when else toSQL as toLiteral

Constructors

constructor

new SimpleCaseBuilder(expr: CaseValue): SimpleCaseBuilder
Parameters
- expr: CaseValue
Returns SimpleCaseBuilder
- Defined in query-builders/functions/conditional.ts:520

Methods

when

when(value: CaseValue, result: CaseValue): this
Add a WHEN <value> THEN <result> branch. Repeatable — call multiple times to add multiple branches, evaluated in order.
Parameters
- value: CaseValue
- result: CaseValue
Returns this
- Defined in query-builders/functions/conditional.ts:531

else

else(value: CaseValue): this
Set the ELSE <value> branch. Optional — omitting it yields an implicit SQL NULL.
Parameters
- value: CaseValue
Returns this
- Defined in query-builders/functions/conditional.ts:537

toSQL

toSQL(): string
Render the CASE expr WHEN ... END SQL fragment (no alias).

Returns string
- Defined in query-builders/functions/conditional.ts:544

as

as(alias: string): [LiteralExpression, string]
Terminal call: returns an [expr, alias] tuple compatible with the existing attributes: [...] pattern.
Parameters
- alias: string
Returns [LiteralExpression, string]
- Defined in query-builders/functions/conditional.ts:559

toLiteral

toLiteral(): LiteralExpression
Use the builder directly wherever a raw SQL literal expression is expected.

Returns LiteralExpression
- Defined in query-builders/functions/conditional.ts:564