I've been experimenting with the combo of the "jq" JSON query language and SQL via a custom SQLite function. I bundled the result as a plugin for my Datasette project: https://github.com/simonw/datasette-jq

Here's an example query: https://datasette-jq-demo.datasette.io/demo?sql=select%0D%0A...