More powerful selection set filtering on many to many relations

[lastmjs]

It looks like filters on relations in selection sets can only filter by the by. This is somewhat useful, but vastly less than what is going to be needed for many use cases. Can we allow filters on relations in selection sets to have all of the capabilities of the filters on find queries? Limit, order by, paging, everything should be possible wherever filters are allowed

[lastmjs]

Or maybe I'm doing something wrong with setting up the relation that is causing it to not fully support filtering?

[lastmjs]

It looks like this is a problem with many to many relationships. Is it currently possible to do filtering in selection sets on a many to many relationship?

[lastmjs]

This might be a duplicate of this: #1343
This issue highlights the problem in a selection set, but under the hood the filtering might all be the same, not sure

[machi1990]

Can we allow filters on relations in selection sets to have all of the capabilities of the filters on find queries? Limit, order by, paging, everything should be possible wherever filters are allowed

This looks like a duplicate of #1122. If so let's close this in favor of the other.

/cc @lastmjs @craicoverflow @wtrocki