Imagine the Reporting Site and the Reporting Unit entities, 1 reporting site has N reporting units.
Currently, If I am in the Reporting Site entity, there is no way to filter reporting sites based on a reporting unit condition using graphql.
Like: Give me reporting sites that have reporting units with the name "CLKVAM" to solve that , we need to go to the reporting unit level and query using a reverse edge
which makes data modeling and querying more complex ... sometimes we even need to do some transformations to remove duplicated data