Nesting queries within active record

[eluser]E.T.Cook[/eluser]
[quote author="Colin Williams" date="1223288986"]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.[/quote]

You are fairly passive aggressive. Utilizing business logic to delineate a poorly formed data tree breaks MVC, not in practice, but in form. What I have already done, and exactly what I was stating prior, is form the tree correctly from the get go, before it is passed to the view.