Show HN: Trdsql – CLI tool that can execute SQL queries on CSV, LTSV, JSON

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