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

     1  query "query_with_no_param_defs"{
     2    description = "query with no parameter definitions"
     3    sql = "select 'ok' as status, 'steampipe' as resource, concat($1::text, ' ', $2::text, ' ', $3::text) as reason"
     4  }
     5  
     6  query "query_with_param_defs_no_defaults"{
     7    description = "query with parameter definitions but no defaults"
     8    sql = "select 'ok' as status, 'steampipe' as resource, concat($1::text, ' ', $2::text, ' ', $3::text) as reason"
     9    param "p1"{
    10      description = "First parameter"
    11    }
    12    param "p2"{
    13      description = "Second parameter"
    14    }
    15    param "p3"{
    16      description = "Third parameter"
    17    }
    18  }