Describe the feature

I would like to be able to order a many-to-many relationship by a pivot table field:

collection() {
    return useRepo(Collection)
        .with('user')
        .with('tracks', q => q.with('user').orderBy('pivot.created_at', 'desc'))
        .find(this.collectionId)
},

I would expect a collection with a tracks array sorted by the created_at field on the pivot model. Is this possible (with Nuxt 2)?

Additional information

• Would you be willing to help implement this feature?
• Could this feature be implemented as a module?

Final checks

• Check existing discussions and issues.