DuckDB as the New jq

Re:DuckDB as the New jq by pgr0ss on Thursday March 21, 2024 @05:32PM (#39784665)

I think that's a fair point. Unnesting arrays in SQL can be annoying. Here is your first example with duckdb:

  duckdb -c \
    "select * from ( \
      select unnest(assets)->>'browser_download_url' as url \
      from read_json('https://api.github.com/repos/go-gitea/gitea/releases/latest') \
    ) \
    where url like '%linux-amd64'"

[ Parent | on HN ]

Re:DuckDB as the New jq by _flux on Friday March 22, 2024 @03:19AM (#39788127)

In case someone else was wondering, one can get a shell-consumable output from that with

  duckdb -noheader -list

[ Parent | on HN ]