Skip to content

CASE expressions

RETURN CASE WHEN 18 >= 18 THEN 'adult' ELSE 'minor' END AS category;

Both searched CASE and simple CASE with match/predicate operands are parsed. The query engine executes COALESCE and NULLIF, but not general CASE expressions.

See supported features for executable alternatives.