[Zope-DB] Database independent SQL

Santi Camps santi at zetadb.com
Fri Dec 5 16:21:27 EST 2003

Hi all,

I'm looking for a way to have advanced database independent SQL.  I know
that ZSQL Methods provide some independent, but there is a lot of useful
functions that vary between databases.  I'm thinking in functions like:

coalesce in postgresql / nvl in oracle
case when in postgresql / decode in oracle 

I've had some searches, but nothing successful.  Anybody knows if there
is some product / module / tool to convert SQL syntax between databases?

If not, I'm thinking into implement some of this syntax conversions, at
least for postgresql and mysql, perhaps also oracle or sql-server.  I'm
not very sure, but it seems not to be a huge project.  What do you think
about this?

Thanks in advance

Santi Camps

More information about the Zope-DB mailing list