I have, however, tried to start using SQL::Abstract when i can.

You can go one step further still, and use DBIx::Simple to actually execute the thusly constructed queries, all in one method call.