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

     1  query "chaos6_query"{
     2      title ="chaos6_query"
     3      description = "Query using the chaos6 connection which contains the options block to verify parsing"
     4      sql = "select case when mod(id,2)=0 then 'alarm' when mod(id,2)=1 then 'ok' end status, unique_col as resource, id as reason from chaos6.chaos_cache_check where id=2"
     5  }