I've been wondering the same thing.

But I don't have any real world experience writing software that actually ends up being used with different databases.

I may use all these abstractions, but really we just use Postgres or MySQL in the end.