I built a new plugin for LLM called llm-jq, which lets you pipe JSON into the tool and provide a short description of what you want, then it uses an LLM to generate a jq program and executes that against the JSON for you <https://simonwillison.net/2024/Oct/27/llm-jq/>

Example usage:

llm install llm-jq
curl -s 'http''s:api.github.com/repos/simonw/datasette/issues' |
llm jq 'count by user login, top 3'