Adding joins to relations

[pnomolos]

I'd like the ability to add join tables to relation so that you could do things such as ordering by a field on the joined table. What are your thoughts on something like this?

[vlucas]

You know I'm going to ask you for a use case :). I have not needed this myself, so I am especially curious now!

[pnomolos]

Sure :)

Devices have and belong to many Categories. Categories belong to Types. Types are ordered. I'd like to order the Categories by the order of whatever Types they're attached to.

[vlucas]

And the categories have no other criteria on which they are ordered? Typically a join table doesn't have any relevant information beyond the foreign key ID's.

[pnomolos]

That's correct. The join table is between Devices and Categories - Categories is not a join table and doesn't have any specific order information.