jsonsqlquery 0.1.1

Query JSON using SQL

jsonsqlquery

Query JSON using SQL.

Examples

Inline SQL query:

cat foo.jsonl | jsonsqlquery --query 'select name, age from data'

SQL query from a file:

cat foo.jsonl | jsonsqlquery --query-file query.sql

Create a SQLite database:

cat foo.jsonl | jsonsqlquery --create-db foo.db

See the examples/ directory.

Caveats

• Booleans are cast to integers.
• Data is assumed to fit in memory.