Tie::Function can be used to bind $dbh->quote to a syntactical hash, so you can interpolate arbitrary strings easier. When I do that I name the hash %Q, and then it's safe to do things like
$sql_text = "select id from mytable where foo=$Q{$foo}"; rather than counting placeholders. On Fri, Feb 8, 2019 at 4:37 PM Mike Martin <redt...@gmail.com> wrote: > 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 > > -- "I don't know about that, as it is outside of my area of expertise." -- competent specialized practitioners, all the time