Feature request: DuckDB extension

[yutannihilation]

Since DuckDB provides parser extension API, I'm wondering if it's possible to make ggsql syntax available within DuckDB.

e.g., https://duckdb.org/community_extensions/extensions/psql

Unfortunately, this is currently C++ only API. I think their plan is to eventually expose this API to C API, which means also available from Rust via duckdb-rs, but I don't know when it happens (Probably after v1.6). Also, I'm not sure how hard the build would be.

I'm not sure if this is even possible, but visualization is what I really want when I use DuckDB!

[eitsupi]

Personally, I'd love to be able to use ggsql (with vl-convert?) to replace youplot.
https://duckdb.org/docs/stable/guides/data_viewers/youplot

[georgestagg]

I'd love to be able to use ggsql (with vl-convert?)

This should pretty much work, though could probably be nicer if we could pipe directly to vl-convert.

ggsql exec \
  'SELECT * FROM ggsql:penguins VISUALISE bill_len AS x, bill_dep AS y, species AS color DRAW point' \
  > spec.json && vl-convert vl2png -i spec.json -o ./out.png