How can I retry a write operation in DuckDB without causing duplicate rows?
In a data ingestion pipeline, I need to insert rows into a DuckDB table using a simple INSERT statement. Occasionally, the operation fails due to a transient issue such as a locked file or a network glitch, and I want to retry the INSERT automatically. However, if the first attempt succeeded but the failure occurred after the commit, a naive retry would inse
duckdb