- allow certain apps to work with any sql dialect (though tbh I question the value of this in the age of docker)
- makes simple selects easier
- enables plugins for web libraries
I think the 3rd thing is the most valuable. If you're in an ecosystem like django / rails, you can consume plugins that integrate with your sql backend and your schema more or less automatically.
> tbh I question the value of this in the age of docker
Haha. In the world outside of HN, big companies enforce specific database servers for reasons such as centralized monitoring, security, compliance and competence. Setting all this aside because of "docker" is classic HN.