[Catalyst] More complex Class::DBI::Sweet usage?

[Jules Agee]

Perrin Harkins wrote:
> What problem are you trying to solve?  How to write a report with
> Class::DBI?  Ideally, don't use Class::DBI for it -- just write the SQL.
> If you really want to use Class::DBI, and the end result can be a list
> of objects of one type, add a custom query using set_sql to the class of
> the object you want to get back.  For example, add a search_by_system()
> query to your User class.  It should do the joins across the tables in
> between.

Perfect, thanks!
-Jules