Hacker News new | ask | show | jobs
by antman 1201 days ago
Very nice! Does anyone know if we can query duckdb with a pandas dialect?
3 comments

Hey, I maintain a tool called siuba that converts pandas methods to SQL, including for duckdb!

* duckdb example: https://siuba.org/guide/workflows-backends.html#duckdb

* supported methods: https://siuba.org/guide/ops-support-table.html

Not Pandas but very similar and (in my very biased opinion) better is PRQL (www.prql-lang.org) which as of yesterday you can now use in DuckDB!

See my comment above: https://news.ycombinator.com/item?id=35027712