Start a "searched" CASE expression: CASE WHEN cond1 THEN result1 [WHEN cond2 THEN result2 ...] [ELSE else] END
caseWhen() .when({ age: { [Op.gte]: 18 } }, 'adult') .else('minor') .as('ageGroup') Copy
caseWhen() .when({ age: { [Op.gte]: 18 } }, 'adult') .else('minor') .as('ageGroup')
Start a "searched" CASE expression: CASE WHEN cond1 THEN result1 [WHEN cond2 THEN result2 ...] [ELSE else] END