Design patterns to ease migration of SQL code between vendors

I am looking at ways which a developer can take advantage of implementation specific advanced features(T-SQL, PL-SQL etc) and at the same time makes it easy to migrate the ANSI com开发者_StackOverflowpliant SQL code to a new database. By that I mean, how to efficiently abstract the ANSI compliant SQL code and move it across different databases?

---

I use the Mimer SQL validators:

Check Your SQL Against the SQL-92 Standard. Mimer SQL-92 Validator recognizes the standards Entry, Transitional, Intermediate and Full SQL-92, Persistent Stored Modules (PSM) SQL-99 and Database Triggers

Copy and paste SQL text into the webpage and hit the 'Test SQL' button.

..though I'm not sure that is the kind of "efficient" process you are looking for, it may of some use.