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.

This happened because the numbers were saved with comma instead of dot for decimal separator. I know that this is not a normal and "valid" operation (multiplying numerics with varchars), but why it ...

They want it to work against MS Access and Oracle to start, with SQL Server being the next 'compatible' databsae. <BR><BR>I haven't really looked at Access lately, and haven't ever really used ...

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.