in reply to
Search for ORM with Multi-Table-Object Support
++ for DBIC
I'm using it in my current project and I also have to build multi-table objects. These are quite large objects in my case with quite a lot of data, so it is split up across tables and I only need to assemble the full object when a single record is selected.
I just have a 'to_xxx_object' method in the result class for the table that stores the bulk of the data, which just gathers all the data from the related result classes and instantiates the big object. You end up with a single place in your code that needs to change if the tables change.