doSelect, doSelectRS/doSelectStmt and doSelectJoin

I have had to recently work on complex queries which involved performing aggregration etc which made it little difficult to stick to the regular data set mapping to a model, as the regular doSelect would try and do a hydrate and since the new columns (say defined by count or avg) wont match with the [...]