Hi, I was wondering if anyone has written a DBI proxy driver which modifies the SQL before passing it to the real database driver. Conceptually it seems pretty straight forward, but I was wondering if there are any gotchas I need to watch out for.
To elaborate on how I intend to use it: I am considering using this to connect an application which uses one flavor of SQL (e.g. Oracle) to another database (e.g. mysql). The SQL transformations would not be very sophisticated - it would be on a query by query basis rather than try to be a generic query translator. That is, as I encounter queries that will not work, I will write code in the proxy to replace them with an alternative query. Has anyone done anything like this before? And if so, any suggestions on how to proceed? Thanks, ER
