Axel RauschmayerAny recommendations for CLI tools for JSON querying? (It should be easy to install on macOS – e.g., via Homebrew.)
I’m only aware of jq. It’s established, but is it still the best choice?
Troy McConaghy@rauschma You can store JSON in a Postgres database; there's a JSON data type. Then you can do JSON-specific SQL queries. More info: https://www.postgresql.org/docs/current/datatype-json.html
Daniel Rotter@rauschma I also only know jq, but what I am also not looking for something else. Why do you? What's wrong with it?
૮༼⚆︿⚆༽つ / Wildan@rauschma try Miller
Ruben Oostinga@rauschma I know the AWS cli uses jmespath, you can use it in isolation here: https://github.com/jmespath/jp
Romain 
@rauschma node & Deno are also to consider... I use them when I can't be bothered with looking up jq's doc again to figure out the name or syntax of some filter 🤣
Jan Andrle@rauschma You can use `node -p …` or `nodejsscript -p` https://github.com/jaandrle/nodejsscript/blob/main/examples/eval_print.md#jq (https://www.npmjs.com/package/nodejsscript).
Also Mastodon thread:
https://fosstodon.org/@jaandrle/109901893985021722
Romain Delamare@rauschma I have not used it, but jless (https://jless.io/) looks cool and is available on homebrew.
Will@rauschma you could have a look at this one, a Rust based one installable with brew install jql: https://github.com/yamafaktory/jql
Ian Sutherland 🇨🇦@rauschma if you’re looking for something interactive jless is nice. https://jless.io/
Max@rauschma Bit of a left field answer: PowerShell
PowerShell has a lot of really interesting general purpose object query tools designed for command line use and ConvertFrom-Json and ConvertTo-Json work really moving from one object system to the other and back.
Of course, PowerShell has quite a learning curve and learning it just for JSON is silly, but the fact that its tools are generally applicable to more than just JSON can be handy.
Ash@rauschma At @sanity_io, we’ve created a language called GROQ for querying data. We have a CLI tool that allows you to run GROQ queries for any JSON or NDJSON data. I find it to be a really expressive way to query data.
