Update JSON output to be consistent across pipelings - also handle duplicate column names

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 JSON output to be consistent across pipelings - also handle duplicate column names #4317

Open pskrbasu opened 1 week ago

pskrbasu commented 1 week ago

Update Steampipe JSON output to align all cases around a single format. Cases:

steampipe query --output json
powerpipe query run --output json
snapshot data format
Pipes query API

Proposed format:

{
  "columns": [
    {
      "name": "foo",
      "data_type": "int4"
    },
    {
      "name": "foo_{random4}",
      "data_type": "int4",
      "original_name": "foo"
    }
  ],
  "rows": [
    {
      "foo": 1,
      "foo_{random4}": 2
    }
  ],
  "metadata": {
   ...
  }
}