Database protocols are outdated and complex, handling mutable state poorly, complicating connection management and error recovery. SQL lacks explicit idempotency, making safe query retries difficult. Introducing features like idempotency keys could enhance retry safety. Prepared statements add overhead and session limitations, suggesting the need for a digest-based system for better resource management. Overall, improving database protocols could significantly enhance developer usability without altering SQL syntax.
https://byroot.github.io/performance/2025/03/21/database-protocols.html