DuckDB as the New jq

https://www.pgrs.net/2024/03/21/duckdb-as-the-new-jq/

48 points · 5 comments · view on lemmy.world

5 Comments

D_Air1@lemmy.ml · 7 pts · 2y (1 reply)

Cool, so jq but using sql instead of custom syntax. I wonder if it can output to plain text. That is what I usually use jq for.

jh0wlett@discuss.tchncs.de · 3 pts · 2y

jq is mot custom syntax though, it is just JSONPath standarsld. Which is also used to query JSON in JSON fields in MySQL for instance.

atzanteol@sh.itjust.works · 4 pts · 2y

That's neat! Reminds me of steampipe which provides a sql interface to apis. You can also use it for csv, json and yaml.

Nice thing about steampipe is that it can look like a postres db to any sql client.

tetris11@lemmy.ml · 3 pts · 2y

DuckDB have been promoting hard these last few weeks. I saw them on HN a few days ago, and now here.

jbrains@sh.itjust.works · 3 pts · 2y

I finally build something nontrivial in jq, then this happens...