Cacher is the code snippet organizer for pro developers

--1
select 
CASE WHEN some_column IS NOT NULL 
  THEN true
  ELSE false
	END AS 'Test'
from some_table;

--2
select 
  some_column IS NOT NULL AS 'Test'
from some_table;