#autocommit

Unresolved behavior of SQLAlchemy merge during retry scenarios

Goal Implement a retry mechanism for write operations that avoids duplicate inserts or lost updates when a transaction is retried after a transient failure. Constraints & Uncertainties Using SQLAlchemy’s merge method to perform idempotent upserts, the session may automatically issue a flush that re‑executes an INSERT if the instance is detached between r