Handy method Zend_Db_Select::assemble() will output the select object's state as sql. Very handy when debugging.