Entity / Expressions
Limits
Expr covers single-row filters, one-relation lookups, and child exists checks:
- Aggregates: Multiplication, division, and aggregates like
COUNTbelong in derived members (Derived.count,Derived.exists), which act as display fields rather than expression operands. - Joins and order: Predicates traverse
onelinks andexists; queries sort only by the root Entity's fields (and non-locale collations for client placement). - Custom operations: Extend the language with domain-specific predicates via Operators.
When a query needs full SQL features outside Expr, register a custom server query source; the client simply re-fetches that list after writes.