DuckDB currently (version 1.3.1) does not have support for MERGE statements to perform upserts in ducklake. This is planned to be added in a future update according to their roadmap. What you can do right now is to perform a DELETE on all rows in the table that has the same ID as the to-be-inserted records and then INSERT the updated records to the table.