/*
if upper(<value>) is 'Y' or 'YES' or 1:
return TRUE
else:
return FALSE
*/
{% macro boolean_flag(column_name) %}
case when upper({{ column_name }}) in ('Y','YES') or to_char({{ column_name }}) = '1' then TRUE else FALSE end
{% endmacro %}