"so they are fundamentally all the same"
Just they don't work exactly the same. Everybody who worked with different RDBMS in the past years had to learn it, sometimes the hard way.
Unless, of course, you use them just as very simple data dumps and all the SQL you need is "SELECT * FROM something" (and even then you may have differences...)
