"It's far easier and much more reliable to use a subset of SQL that's common to the major relational database systems commonly used today." I think that is gen

"It's far easier and much more reliable to use a subset of SQL that's common to the major relational database systems commonly used today." I think that is generally a mistake for non-trivial applications. MySQL and SQLite are so far from the standard that it's just not worth trying to find a subset of SQL that works the same on those systems as the others. The similarities between the SQL implementations do make porting easier, however. But I consider it a port rather than using a common subset.