jql

Command-line tool for querying and filtering JSON data with a SQL-like syntax

brewmacoslinux
Try with needOr install directly
Source

About

JSON query language CLI tool

Commands

jql

Examples

Select specific fields from a JSON object$ jql '.name, .email' data.json
Filter JSON array elements by condition$ jql 'select * from . where age > 30' users.json
Query nested JSON structures$ jql '.users[] | select(.status == "active")' config.json