@j.j you can try your hand at the new

N/query

module, see if it supports the joins you need