Case

is currently experimental and may change behavior in the near future

case was previously (PRQL 0.4 to 0.5) called switch and renamed to in PRQL 0.6.0.

PRQL

SQL

If no condition is met, the value takes a null value. To set a default, use a true condition:

PRQL

SQL