I like SQLite and JSON columns. I wonder how fast it would be if you save the whole JSON file in one record and then query SQLite. I bet it’s fast.

You could probably use that one record to then build tables in SQLite that you can query.