Description
The Typed Dotabase Query DSL is the shared contract for filtering, sorting, grouping, paginating, faceting, searching, and aggregating rows.
Typed Dotabase Query DSL is delivered through typed package contracts rather than a surface-specific shortcut. Its primary modules separate the public input or configuration shape from validation, durable state, and the operation that produces the result. That separation lets product surfaces and integrations invoke one implementation while tenant scope and existing domain rules remain in force. Errors stay bounded to the request instead of weakening the underlying data contract.
Selling Points
- Gives UI, CLI, MCP, and API callers one query vocabulary.
- Validates property-aware operators before execution.
- Keeps tenant and archive constraints inside compiled queries.
- Applies one typed package contract across every supported caller and surface.
- Keeps invalid inputs and unavailable dependencies from silently widening durable state.
User Story
As an integration developer, I express a complex saved-view query once and receive consistent results across surfaces. In practice, I configure or invoke the capability through a supported surface, supply only the inputs its contract accepts, and receive a result governed by the same rules as every other caller. I can inspect the resulting row, setting, event, or query state and correct my input when validation fails. I walk away with a repeatable workflow rather than a one-off client implementation.
Extension Surface
Automatable: external callers compose documented query objects; the operator and serialization vocabulary is platform-defined.
The automatable rating is evidenced by packages/dotabases/src/query/types.ts, which defines the supported seam used by trusted callers or configuration. The capability can be composed wherever that contract is available, but its invariants are not replaced by tenant-authored executable code. This keeps extension honest: callers control documented inputs and policy choices while the package owns validation and safety.
Capabilities & Limits
- Capability: Executes the scoped workflow described above through the cited live implementation paths.
- Capability: Preserves typed validation and applicable tenant, schema, lifecycle, or service boundaries.
- Limit: Supports property and system columns, FTS, vectors, RRF, facets, and aggregates. A quick-preset translation layer is not yet shipped here. Typed Dotabase Query DSL supports the concrete operations described here and composes them with tenant, schema, or lifecycle checks already owned by the package. It does not grant raw database access, make unsupported inputs valid, or assume that optional providers and downstream consumers exist. Callers remain responsible for permissions and meaningful configuration, and product rendering or external delivery stays outside the package unless explicitly stated.
Implementation Map
packages/dotabases/src/query/types.tsRowQuerypackages/dotabases/src/query/row-query.tsserializeRowQuerypackages/dotabases/src/query/aggregate-query.tsserializeAggregateGroups