The most common approach is to read Postgres data in DuckDB https://duckdb.org/docs/extensions/postgres.html