Re: Translate between DBI and SQL

2019-02-08 Thread John Scoles
Well not really much DBI can do for you. You usually start from scratch trying to write SQL that is not Driver Specific though that can be hard. you are usually stuck with something like this sub edit_sql { my ($self, $sql) = @_;​ ​ if ($self->isPostgres) {​ return

Translate between DBI and SQL

2019-02-08 Thread Mike Martin
Has anyone done any work on converting SQL queries between RDBMS and perl? My particular interest is DBD::Pg but anything would be of use It would be very useful when I am testing complex SQL, it's very easy to miss a \ or quote between the two Thanks Mike