You can construct a query SQL statement to query data from a local database. You can create a TestCriteria object (in this example, AttributeTest) to filter results. You can also query across multiple tables (MBOs) when using the executeQuery API.
Query query2 = new Query();
query2.Select("c.fname,c.lname,s.order_date,s.region");
query2.From("Customer", "c");
//
// Convenience method for adding a join to the query
// Detailed construction of the join criteria
query2.Join("Sales_order", "s", "c.id", "s.cust_id");
AttributeTest ts = new AttributeTest();
ts.Attribute = ("fname");
ts.TestValue = "Beth";
query2.Where(ts);
QueryResultSet resultSet = SUP101DB.ExecuteQuery(query2);