Viewing/Sorting/Searching/Filtering on relationship fields' related fields

[tyteen4a03]

In CRMs like Dynamics 365, you can view/sort/filter on a field based on a relationship field (e.g. if you have a Post entity that has a category relationship field, you can view/sort/filter by the fields on the category entity).

It would be great if Payload can implement this feature as well. Currently, I use a lot of caching to mock this functionality.