Jelte Fennema-Nio

Handle auth_query correctly for replication connections

1

The way we send an auth_query is a bit strange. We temporarily set the pool of the client to the pool for the auth_user, and then continue connection startup like...

Unable to use duckpgq in DuckDB its `query` table function

2

### What happens? When I use a duckpgq query inside a call to DuckDB its `query` table function it throws an error that it expects a single SELECT statement: ```sql...

We were adding hints to queries to which they did not apply. This is unhelpful and confusing for users. So this makes some changes to our logic for adding these...

Initial draft API to upgrade to DuckDB 1.3.0 This can only be merged after 1.3.0 is released, but probably we want to merge against a nightly or release candidate release...

This is a draft of an updated changelog of the changes we have so far for 1.0.

### Description Changes to MotherDuck tables are only synced to PG while queries are actually happening. We should document this.

### Description DuckDB 1.3 is slated for 21st of May. We should try it out now to make sure that we can upgrade quickly then.

### Description With the new secrets design it should be possible to use it for read scaling, and use different secrets for different users.

### Description This section is incorrect now: https://github.com/duckdb/pg_duckdb/blob/main/docs/motherduck.md#non-supersuer-configuration Maybe more. We should go over the motherduck related docs and try all the commands to see if they are still correct.

Add support for functions related to the DuckDB MAP type

2

### Description Support for the DuckDB MAP was added in #689 and expanded in #773. What's still missing though is support for the functions that DuckDB provides to interact with...