jqjq

jq is such an underrated tool, it is fully turing complete functional language in and of itself. It opens up an ocean of possibilities in combination with scripting languages (python has bindings), and it is ungodly fast chewing up through tons of JSON like its nothing. It is a bit perl-ish, but being pure and functional it is a little easier to reason about when you have to revisit your queries. PS I am certainly bookmarking your tool as well =] There is also amusing project jqjq that implements jq in jq itself that I love to point folks at to show how expressive the language is: https://github.com/wader/jqjq

JQ is an insanely powerful language, just to put to rest any of your doubts about what it is capable of here is an implementation of JQ... in JQ itself: https://github.com/wader/jqjq It really is a super cool little, super expressive nearly (if not entirely) turing complete pure functional programming language. You can: * Define your own functions and libraries of functions * Do light statistics * Drastically reshape JSON data * Create data indexes as part of you JQ scripts and summarize things * Take JSON data, mangle it into TSV and pipe into SQLite cat data.json | jq '<expr>[]|@tsv' | sqlite3 -cmd ".mode tabs" -cmd ".import /dev/stdin YourTable" And also for prototyping you can also use it to tailor output of APIs to what you need in a pinch, using JQ as a library especially with something like python: https://pypi.org/project/jq/

Some joke/useless software i've written: - https://github.com/wader/jqjq - https://github.com/wader/flac.tcl In most cases i learned way more then i expected. Even made some friends.

Being a long time personal friend with the author I can assure you the more obscure the better :-) His interest in esoteric things and solutions are "well documented" if you browse around his github repos. Some examples: https://github.com/wader/jqjq https://github.com/wader/catgolf