After some chat in IRC i realized that i was communicating my intent wrongly. The purpose of this is not to create SQL queries. The main focus here is on how to store and access them in a lightweight and elegant manner.
Thanks for the suggestion, but neither of these really seem useful to me. SQL::Library has no templating at all and Phrasebook::SQL completely takes over the SQL access, so that things like selectall_hashref become inaccessible.
However, looking at it, Data::Phrasebook looks to be interesting, so thanks for that. :)