[DB-SIG] Database Independent SQL
Mon, 9 Sep 2002 11:44:31 +1000
I'm about to develop a major Python application and was wondering what the
most database independent way of going about accessing a database in my
application. i.e so I can switch between databases almost instantly (a
little bit of work is also okay :-)).
I know the DB API 2 handles the connection, querying etc. in an independent
manner but what I am also looking for is some sort of library which provided
a standard SQL syntax as well.
I still want the power of SQL but would like a library which would translate
a standard set of SQL syntax to all the slightly varying SQL syntaxes of the
different databases out there.
I'm not a big fan of OR mapping tools because their querying abilities are
too restrictive and IMO reinventing the wheel in many instances.
Thanks in advance for all your responses,