Have you seen the Buenavista proxy server? It imitates Postges over DuckdDB. I use it in production for dbt queries, including inserts and updates.