So we could use this with Postgres by putting DuckDB in front with its Postgres extension, pointing to the source data in PG?

In principle, yes, that’s the idea! However I will say we have focused mainly on the grammar and using DuckDB for reading from local files for this alpha release, so I expect there may be some bugs around connecting to remote databases still to iron out!