i've been using simonw's sqlite-utils (https://sqlite-utils.datasette.io/en/stable/ https://sqlite-utils.datasette.io/en/stable/) for this sort of thing; given

i've been using simonw's sqlite-utils (https://sqlite-utils.datasette.io/en/stable/ https://sqlite-utils.datasette.io/en/stable/) for this sort of thing; given structured json or jsonl, you can throw data at an in-memory sqlite database and query away: https://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database https://sqlite-utils.datasette.io/en/stable/cli.html#queryin...