Joins: Controller or Model?

[eluser]Denarius[/eluser]
Thanks for pointing me to the article. Lets see if I've got the gist of it.

As far as I can see, the Model class in the framework is doing the object-relational mapping as queries return rows of objects based on the fields in the relevant table. In the case of a join though you would need to extend the model with the join query. In my specific case I'm looking at compositions and arrangements of compositions, so in that specific case I would be extending the arrangements model to include the left join query beyond the standard queries as determined implicitly by the Model class in the main library.

Am I on the right track or am I still missing something?

Update: I meant compositions and arrangements in a musical sense rather than compositions in objective framework programming. Should've explained that. :red: