Any alternative of CASES keyword in Crate?

CrateDB SQL
1

Need alternative of CASES in Crate?
For e.g.
(case when user_role = ‘student’ then ‘622057’
when user_role = ‘assistant’ then ‘2913659’
when user_role = ‘admin’ then ‘6160230’
end),
Need to update certain fields with multiple conditions.

2

we do support CASE for quite some time: https://crate.io/docs/crate/reference/en/latest/general/builtins/scalar.html#conditional-functions-and-expressions.