Complex Querries with Torque

Hi all, 

I'm developing an application that will user Torque to manipulate a
MYSQL database.It will be using many of the complex SQL constructs:
multi table joins, complex logical conditions in the where statement,
summation of values, etc. Looking at the doSelectTable() methods in the
BaseTablePeer object of my application, I see that much of the join is
performed on the application side, and not on the database side. 

I need to take full advantage of the optimization of the database, so
this doesn't seem like a good option. Is there any other way to join
multiple tables with WHERE conditions then to extend the existing
classes?

Thanks,



Chris