[Zope-DB] Database independent SQL

[Dieter Maurer]

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.

-- 
Dieter