Nesting queries within active record

[eluser]Colin Williams[/eluser]
Not a purist. You just don't appear to understand what MVC is. When you structure data, guess what you are doing. Modeling it. Please explain how iterating over a query result to structure data "breaks hard MVC methodology."

Edit:

Actually, I think you are confused by our suggestion. We suggest this iteration happens in the model, before returning to the controller and/or view. Not sure why you immediately assumed this has to happen outside the model. Nearly every model I write has a _build_object($result) method that does this very thing.