3 ms·
I've been playing with Steampipe a bit and it's really great, but unfortunately the SQL language lets it down a bit because of the structure of the language. T
by amanzi 5y ago
I've been playing with Steampipe a bit and it's really great, but unfortunately the SQL language lets it down a bit because of the structure of the language.
To explain... Steampipe has this amazing autocomplete functionality so you don't even have to know the table name you want - you can just start typing the table name and it will show you the list of possible matches. But because you have to type the "column names" before you type the "table name", Steampipe is unable to offer any autocomplete on the available attributes.
For example, instead of typing: `SELECT name, create_date FROM aws_iam_role` it would be much better if you could type: `FROM aws_iam_role SELECT name, create_date`. That way, Steampipe would be able to autocomplete the attributes available for each object.
- Arnavion 5y agoYes. LINQ (C#'s DSL for SQL-like queries) puts the equivalent of the FROM clause ahead of the equivalent of the SELECT clause for the same reason; IDEs can autocomplete the SELECT clause that way.