Description

We currently don't configure the temp_directory setting of DuckDB. We should do so and set it to an actual temp directory by default, i.e. in the temp directory of postgres.

We should also allow people to override this default by setting the duckdb.temp_directory GUC.

Partially fixes #666