Add support for passing args to non-interactive queries

[johnsmyth]

Is your feature request related to a problem? Please describe.

At present, there is no way to pass arguments to parameterized queries when running steampipe query non-interactively. In the past, you could use a named query as a workaround, but this capability is being removed in a future version (mod support is being removed as part of the unbundling of Powerpipe).

Describe the solution you'd like Add support for passing --args to be passed into the query.

steampipe query my_query.sql --arg "arg 1" --arg "second arg"

This should work for both .sql files and queries in the command, and should behave the same as Powerpipe:

• you may pass more than one --arg
• args are positional and the order determines to which parameter they refer - the first --arg is $1, the second is $2, etc

Unlike powerpipe, steampipe allows more than one query to be passed to a single command. In this case, the same set of args should be passed to all the queries, in the same order.

Additional context https://turbot-community.slack.com/archives/C01UECB59A7/p1710947264260629

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.