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.