Case

Case expression

Case expression is similar to Switch Expression in many languages, it's return the value of the first branch that has condition evaluated to true, if not branch found it will return the default value

SELECT name FROM branches WHERE (CASE WHEN isRemote THEN 1 ELSE 0 END) > 0