That's true, even with "perfect" abstractions, switching gets more complicated as you use more complex database features. It's only really easy if you push mos

That's true, even with "perfect" abstractions, switching gets more complicated as you use more complex database features. It's only really easy if you push most of your constraints and triggers to the application. In practice, I've only ever switched databases with really simple CRUD stuff and have otherwise been able to predict that I'll eventually want Postgres/RabbitMQ/etc and build it in from the start.