DuckPGQ support? #153

tsilvs · 2025-06-05T11:15:53Z

tsilvs
Jun 5, 2025

Having DuckDB integrated in the module, can we run DuckPGQ queries as well?

Answered by dpxcc

I think there are three different ways to run DuckPGQ queries in Postgres:

Run DuckPGQ queries in Postgres directly
This is not possible because Postgres currently doesn't allow extensions to change Postgres parser
Create a Postgres UDF mooncake.DuckPGQ("<query>") and ask users to pass DuckPGQ queries as string to the UDF
This is doable but not very user-friendly. Also, this won't support prepared statements which are commonly used by apps to interact with the database
Expose DuckDB sessions from Postgres
We are actually exploring integrating DuckDB-UI (https://duckdb.org/2025/03/12/duckdb-ui.html) from Postgres to allow native DuckDB queries, including DuckPGQ queries

dpxcc · 2025-06-05T18:10:07Z

I think there are three different ways to run DuckPGQ queries in Postgres:

Run DuckPGQ queries in Postgres directly
This is not possible because Postgres currently doesn't allow extensions to change Postgres parser
Create a Postgres UDF mooncake.DuckPGQ("<query>") and ask users to pass DuckPGQ queries as string to the UDF
This is doable but not very user-friendly. Also, this won't support prepared statements which are commonly used by apps to interact with the database
Expose DuckDB sessions from Postgres
We are actually exploring integrating DuckDB-UI (https://duckdb.org/2025/03/12/duckdb-ui.html) from Postgres to allow native DuckDB queries, including DuckPGQ queries

0 replies