github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/acceptance/test_data/mods/functionality_test_mod/query/static_query.sql (about)

     1  select 
     2      case
     3          when num=1 then 'ok'
     4          when mod(num,2)=0 then 'alarm'
     5          when mod(num,3)=0 then 'ok'
     6          when mod(num,5)=0 then 'error'
     7          when mod(num,7)=0 then 'info'
     8          when mod(num,11)=0 then 'skip'
     9      end status,
    10      'steampipe' as resource,
    11      case
    12          when num=1 then 'ok'
    13          when mod(num,2)=0 then 'alarm'
    14          when mod(num,3)=0 then 'ok'
    15          when mod(num,5)=0 then 'error'
    16          when mod(num,7)=0 then 'info'
    17          when mod(num,11)=0 then 'skip'
    18      end reason
    19  from generate_series(1, 12) num