elastic search sql query result to json(ndjson)

elasticsearch_queryresult_ndjson.sh

#!/bin/bash

cat result.json | jq -c ' { "col": [.columns[] | .name], "row" : .rows[] } 
	| [.col, .row] 
	| transpose 
	| map({ (.[0]): .[1] }) 
	| add ' >