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

     1  query "array_arg" {
     2    description = "test array argument"
     3    sql = <<-EOQ
     4        select
     5         name
     6        from
     7          aws_iam_user
     8        where
     9          arn = any($1::text[]);
    10  
    11        EOQ
    12  
    13    param arns{
    14      default = [
    15        "arn:aws:iam::876515858155:user/lalit",
    16        "arn:aws:iam::876515858155:user/mike"
    17      ]
    18    }
    19  }
    20  
    21  query "single_arg" {
    22    description = "single arg"
    23    sql = "select $1"
    24  
    25    param p1{
    26      default = "foo"
    27    }
    28  }