[SQLObject] Custom query results?

Hi all,

I was wondering if it was possible to attach columns from another table (a
many-to-many relationship table) to results returned from er-- that other
table.

To use an example from the SQLObject documentation:
http://sqlobject.org/FAQ.html#how-can-i-define-my-own-intermediate-table-in-my-many-to-many-relationship

Is it possible to have User.roles return the Role information along with
'active' from the UserRoles class? How might this be done?

Thanks again!