If you need a module that could help you form complicated but recurring queries you can look at DBIx::SearchProfile. With this module you can create your own templates of typical queries and reuse them easily with minimum of code to write.

If you need a module to provide good SQL abstraction you can try DBIx::Abstract.

And at last but not least, you can try various RDBMS-OO mappers that could raise you abstraction level from tables and SQL-queries to object data model. I prefer Alzabo for my own.

-- brother ab