turbot / steampipe

Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.
https://steampipe.io
GNU Affero General Public License v3.0
6.67k stars 262 forks source link

Update query JSON output to be consistent across pipelings - also handle duplicate column names. Closes #4317 #4318

Open pskrbasu opened 1 week ago

pskrbasu commented 1 week ago
steampipe query "select account_id as a, account_id as a, organization_id as a, account_aliases, title from aws_account" --output json
{
 "columns": [
  {
   "name": "a",
   "data_type": "text"
  },
  {
   "name": "a_voay1",
   "data_type": "text",
   "original_name": "a"
  },
  {
   "name": "a_voay2",
   "data_type": "text",
   "original_name": "a"
  },
  {
   "name": "account_aliases",
   "data_type": "jsonb"
  },
  {
   "name": "title",
   "data_type": "text"
  }
 ],
 "rows": [
  {
   "a": "45xxxxxxxxxxx",
   "a_voay1": "45xxxxxxxxxxx",
   "a_voay2": "o-cxxxxxxxxxxx",
   "account_aliases": [
    "redhood-aaa"
   ],
   "title": "redhood-aaa"
  }
 ]
}