github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/demo/query_param_demo/query.sp (about)

     1  variable "v1"{
     2      type = string
     3      default = "from_var"
     4  }
     5  
     6  
     7  query "q1"{
     8      title ="Q1"
     9      description = "query 1 - 3 params all with defaults"
    10      sql = "select 'ok' as status, 'foo' as resource, concat($1::text, $2::text, $3::text) as reason"
    11      param "p1"{
    12          description = "p1"
    13          default = var.v1
    14      }
    15      param "p2"{
    16          description = "p2"
    17          default = "because_def "
    18      }
    19      param "p3"{
    20          description = "p3"
    21          default = "string"
    22      }
    23  }
    24  
    25  
    26  query "q2" {
    27      title       = "EC2 Instances xlarge and bigger"
    28      sql = "select 'ok' as status, 'foo' as resource, $1::jsonb->'a' as reason"
    29      param "p1"{
    30          description = "p1"
    31      }
    32  }
    33  
    34  query "q3" {
    35      sql = "select * from chaos_all_column_types where string_column like any($1)"
    36      param "p1"{
    37          default = ["stringValuesomething-13","stringValuesomething-7"]
    38      }
    39  }