Start a "simple" CASE expression: CASE expr WHEN val1 THEN result1 [WHEN val2 THEN result2 ...] [ELSE else] END
The expression being compared. A plain string is treated as a column name (identifier-escaped); pass col('name'), fn(...), or literal(...) for other expression types.
col('name')
fn(...)
literal(...)
caseOf('status') .when('active', 1) .when('inactive', 0) .else(null) .as('statusFlag') Copy
caseOf('status') .when('active', 1) .when('inactive', 0) .else(null) .as('statusFlag')
Start a "simple" CASE expression: CASE expr WHEN val1 THEN result1 [WHEN val2 THEN result2 ...] [ELSE else] END