I'm working on a similar project (Access, Oracle, and Sybase, with SQL Server to come), and here's what we've found, as far as I know:<BR><BR>Mostly ANSI SQL will convert without changes.

The goal of pypika is not to map a common syntax to multiple DB platforms, but rather to provide a syntax that wraps the SQL you would be writing without it.

Learn how to avoid syntax, logic, performance, security, and data errors in SQL for data analysis, and improve your SQL queries with tips and best practices.