Until you realize that not even booleans are standardized between SQL dialects...
That's true in theory, but unfortunately you can still run in to issues when different databases support different parts of SQL, and the db you're migrating from has different features than the one you're migrating to.
There are a huge number of differences in the SQL supported by different engines. You can't just switch from one to another, unless you're only using a small subset of SQL to begin with.
How do you insert a row and get the automatically set Id set by the database portably? That’s a standard create operation.