Show HN: Trdsql – CLI tool that can execute SQL queries on CSV, LTSV, JSON (github.com)

Another way to aggregate json(jq + SQL) https://noborus.github.io/blog/jqsql/