[Zope-DB] Database independent SQL
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
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