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 is clearly an advantage to use only the standard SQL-92 commands. Mimer has published this SQL validator which verifies compliance with such standards.