From pod:

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.

/brother t0mas