[SQLObject] Approach to large joins

[Simon R. <sro...@be...>]

I've been using the basic SQLObject APIs  very happily for the last  
year. Thanks for all the hard work.

I have a question as to what is the best approach to the following -  
I want to do a join across multiple tables potentially returning lots  
of rows. I do this with MyClass.select which gives me the attributes  
for MyClass. If I want to report the cols of the other tables I have  
to follow the joins I've set up in my classes, while this works fine  
it's not very efficient because as far as I can see another query  
happens every time I use one of these pre-set up joins.

I know I can use a raw query in these instances but I would then miss  
out on my customised columns and object oriented approach.

Is there some sort of way of having a composite object which contains  
all the classes I wanted in the join? Is there some other approach  
I've missed entirely? I noticed something relevant in the SQLBuilder  
& Views thread from Johan Dahlin a few weeks ago is that what I  
should be looking at?

On another vaguely related question - is there a proper way to  
execute a (sub)query built with sqlobject.sqbuilder.Select  
standalone. I can sometimes get a str representation and pass that to  
queryAll but not always...

Cheers.