You can define very complex object models and relationships easily using the powerful ObjectExtender tool set. The underlying query model is expressed in object terms rather than on database-specific native terms. Several kinds of mapping strategies encourage this loose coupling.
The code-generation function produces sophisticated SQL statements customized for your object model. The SQL statements are consumed by service classes that manage your data. Because the code-generation is done at development time, you can benefit from the advantages of static SQL or tune them as desired rather than having them generated at runtime.
Figure 6. Advanced query capability. Class hierarchy queries are expressed in object terms.
The query generator supports: