[Zope-DB] Database independent SQL

Dieter Maurer dieter at handshake.de
Sat Dec 6 16:26:31 EST 2003

Santi Camps wrote at 2003-12-5 22:21 +0100:
>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?

ODBC might be an option for you.
It standardizes a large SQL subset.
It is available not only for Windows but for Unix, too.


More information about the Zope-DB mailing list