postgres_scanner

postgres_scanner copied to clipboard

Nice to have possibilities to pass parameters through duckdb direct to the complex posgres query like

with pgdata as (
     select * from postgres_query(pg, $$select * from some_pg_table where some_pg_column = 1 $$, $1)
)
select *
from some_duckdb_table
           inner join pgdata on some_duckdb_table.duckdb_id = pgdata.pg_id

It will make duckdb more useful in production use cases.