This module is very interesting, as it allows to keep your code "perlish" without inlining ugly SQL code.
It's nearly perfect, as subselects are not supported yet, but it is enough for most tasks. The where method can be used to create just the search statements, which will allow you to make queries with joins.
The DBIx::Class ORM relies on it and - in my opinion - SQL::Abstract gives the best when used inside DBIx::Class. It's - however - very useful anyhow.
Catalyst is the new frontier of web development: it's easy, productive, elegant and fun.
It really pays to spend some time learning the philosophy of Catalyst and MVC, and the use of the wonderful (somehow) Catalyst-related modules such as DBIx::Class and HTML::Widget. Your way to develop web applications will be shaken from the roots, and you'll be able to focus on what you really need to do, not on always-the-same tasks and bloated-code-fight.