The current version of the module works with single table SELECTs
only, although the basic design of the SQL::Statement module allows
joins and the like.
So the answer is: Do it yourself.
If someone did this (plus some other stuff) to CVS it would be very useful.