Any pointers on CakePHP and “report” type views (ie selects with left joins, aggregate functions, group by, order by etc.)?

First basic CakePHP app done. Actually simpler than working with my own framework.

Missing having Lambda expressions to define redirect to actions in CakePHP, like I have in ASP.Net MVC… Have to hard-code strings. Yuck!

Gonna learn a PHP framework so I can stop wasting time maintaining my own. My short list: CodeIgniter, CakePHP, Zend. Any thoughts tweeps?