Sometimes, you need to quickly dump a json file into sqlite, just to run some queries on it. This is a two-step process:
cat file.json | jq -r '.data | map([.field1, .field2, .field3] | @csv)| join("\n")' > file.csv
ex -sc '1i|field1,field2,field3' -cwq file.csv
$ sqlite3 file.sqlite
SQLite version 3.24.0 2018-06-04 14:10:15
Enter ".help" for usage hints.
sqlite> .mode csv
sqlite> .import file.csv data
sqlite> .tables
data
sqlite> .schema dat
CREATE TABLE incidents(
"field1" TEXT,
"field2" TEXT,
"field3" TEXT
);
sqlite> select count(*), field3 from data group by field3;
3,test3
1,test1
sqlite>