araddon/qlbridge

Case when or If else isn't working

brachipa opened this issue · 0 comments

Trying to run sql with case when syntax

SELECT     
      CASE 
          WHEN event = 'ABC' AND THEN '1'
          WHEN event = 'XYZ' AND THEN '2'
      END AS ExpireOn
FROM some_table

Looks like it isn't supported.

I see only if examples:

email IF email NOT IN ("hello")

But what should I do if I need else option.

maybe you have even a workaround?