Matthew's Journal

Kind of echoing womble2—by the time you've dealt with porting your SQL to your new backend, things like the parameter styles become incidental. (My experience of this is grafting Firebird support into a program which already handled Oracle and MySQL. If you've already got a class (or other) interface which hides the DB-API from the rest of your program, the headache is entirely in the differences in SQL dialect. Even differences of opinion on paramstyle can be ameliorated by judicious use of a %-substitution to build a query with parameters. Do not go to comp.lang.python for advice, for they will tell you to use SQLAlchemy or some such ORM.)