User pending requests to join nodes

Hi,

Does anyone know if we can get a list of nodes the user has requested to join but still pending, and if yes, how?

We can only do:

SELECT * FROM membership_requests WHERE node.id = 'grouphub:Cats'

and we cannot constraint query with user.id.

If we want to check whether a user requested to join a list of nodes, we need to grab all the users that requested to join each of those nodes and compare it with our currently logged user to see if they have a pending request. That seems like a lot of things happening on the backend to get a list.

Has anyone explored this? Are there any ways to get a list of nodes the user requested to join?

Oh yeah, haven't gotten any better results with restBuilder and trying subqueries on nodes. It's not a top level field. Was expecting to have that information in the user_context in nodes.