Any 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?

@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
8.14. JSON Types

8.14. JSON Types # 8.14.1. JSON Input and Output Syntax 8.14.2. Designing JSON Documents 8.14.3. jsonb Containment and Existence 8.14.4. jsonb …

PostgreSQL Documentation