1. A method for modifying of a query that includes a JOIN clause, the method comprising: determining whether one or more data structures in a JOIN clause of a query include a parent/child relationship; responsive to determining that the one or more data structures in the JOIN clause of the query include a parent/child relationship, determining whether the query that includes the JOIN clause includes a filter applied on one or more data structures in the JOIN clause with an OR condition between filters; and responsive to determining that the query that includes the JOIN clause does not include the filter applied on one or more data structures in the JOIN clause with an OR condition between filters, modifying the query that includes the JOIN clause to utilize relationship constructs corresponding to the determined parent/child relationship between the one or more data structures in the JOIN clause of the query.