I have worked in massive DBs (tables with billions of rows) in both Postgres and MySQL. I occasionally have to look at docs to figure out if what I want to do is supported by the particular version, but that’s about it.

There is a standard SQL, and vendors are free to add to it. Generally speaking, though, you can get quite far with the standard.

> there is no serious application development without having to delve into the sanctum sanctorum of your database vendor.

OK? I could say the same thing about needing to intimately know the differences in C++ versions. Yes, you should know your tools well.