Now, using hibernate (it's actually a spring-boot 3.3 application), I am trying to insert data into the table and the (generated) prepared statement throws a Systax Errror.

Despite having set pg_use_binary_copy=true, if the target table has a column with NUMERIC type then text format is used (instead of binary) when copying data from DuckDB to PostgreSQL. Create a DuckDB ...