Nesting queries within active record

[eluser]Colin Williams[/eluser]
I'm saying you do it in the model before it gets to the view. So we actually agree. Unless perhaps you write and use a stored procedure, your SQL query isn't going to return it in the format you want. You have to manipulate it.

Utilizing business logic to delineate a poorly formed data tree breaks MVC

Again, it has to happen if your SQL query doesn't give you the perfect format. This is what models are meant for. Modeling/forming data.