Powerful Query API

TerraFrame MOJO provides several convenient query options, including queries on objects, queries for presentation views and queries for values on objects. Developers who are familiar with SQL will find the query API simple to use and nearly as expressive as SQL.

In MOJO, query classes that allow developers to specify type-safe queries are automatically generated. These queries are converted to SQL, and the results are automatically mapped back to objects of the expected runtime type. All of the work is performed in the database, and the end results are converted to objects. This avoids many of the problems associated with other ORM solutions which perform aggregate functions on objects in memory rather than in the database.

Non-developers will find the queries easy to read and will be able to easily understand what type of operation is being performed. This is of great importance, since it is often necessary for a project manager or customer to audit code shoulder to shoulder with the developer to ensure that the correct business processes are being modeled.