Inheritance

The inheritance rules are used by default in all queries.

For example

var res = db.ExecuteQuery("SELECT BasicUser");

This query returns all BasicUser, PaidUsers and AdUsers

If you want to retrieve only BasicUser, you should use the ONLY keyword:

var res = db.ExecuteQuery("SELECT ONLY BasicUser");

If you perform a query using field, then inheritance rule applies:

var res = db.ExecuteQuery("SELECT BasicUser WHERE UserSchool.Name = 'Thornleigh School'")

In this case, engine searches UserSchool.Name among BasicUsers, AdUsers and PaidUsers.