The article should mention ClickHouse, which fixes almost all the mentioned problems.
It has idempotency tokens for INSERTs, it has type-safe prepared statements that are easy to use, and the settings can be passed at the query time to avoid the session state.
It has idempotency tokens for INSERTs, it has type-safe prepared statements that are easy to use, and the settings can be passed at the query time to avoid the session state.
I've covered these advantages in my presentation, https://presentations.clickhouse.com/2025-meetup-seattle/ - after the "How Is It Possible?" section.