I don't see how this is a problem for graphql or hasura. If your UI allows all those filter combinations and joins, then your backend needs to allow it too and

I don't see how this is a problem for graphql or hasura. If your UI allows all those filter combinations and joins, then your backend needs to allow it too and you'll have to make it performant no matter what stack you have on the backend. If you don't allow it in the UI then there's no problem if the backend allows it or not, because it's not supported behavior.