This can be done using duckdb_fdw. It needs one additional copy though.

You insert into the duckdb table and then export from duckdb using duckdb_execute.