Almost all relational databases extend the standard set of SQL commands. If these extensions are used, then portability rapidly degrades.
In some applications, such portability may not be a concern. However, if portability is important, then it's clearly an advantage to use only the standard SQL commands. Mimer has published this SQL validator which verifies compliance with different versions of the SQL standard.