This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.
CASE
CASE in Query Engine SQL.
Last modified on October 15, 2026
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
CASE in Query Engine SQL.
SYNTAX - CASE
WHEN condition1 THEN result1
[WHEN condition2 THEN result2 ]
[WHEN ......]
[ELSE default ]
END
> select col1,
case
when col1 < 0 then 'res1'
when col1 > 0 then 'res2'
else 'res3'
end as result
from table