Entity / Expressions

Limits

Expr covers single-row filters, one-relation lookups, and child exists checks:

  • Aggregates: Multiplication, division, and aggregates like COUNT belong in derived members (Derived.count, Derived.exists), which act as display fields rather than expression operands.
  • Joins and order: Predicates traverse one links and exists; 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.