As mentioned here, PostgREST is able to filter and order by foreign columns when using join syntax.
Adding support for this feature would be very useful 🙂