DuckDB as the New jq

DuckDB as the New jq

The DuckDB CLI tool can query JSON files directly, making it a surprisingly effective replacement for jq. Paul Gross demonstrates the following query:

select license->>'key' as license, count(*) from 'repos.json' group by 1

repos.json contains an array of {"license": {"key": "apache-2.0"}..} objects. This example query shows counts for each of those licenses.

Via lobste.rs

apache array cli count duckdb example files json key license making objects query replacement shows sql tool