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