id
as a field name in DQL queriesSYSTEM:COLLECTIONS
and SYSTEM:ALL_COLLECTIONS
virtual collections for listing accessible collectionsUSE IDS
clause now accepts expressions that can be statically evaluatedSET a.b = 1, a.c = 2
)DQL_STRICT_MODE
, delivers powerful new DQL features such as DISTINCT
selection and advanced scalar functions, and improves performance and reliability across replication, storage and query execution. Added:DQL_STRICT_MODE
can now be toggled directly from the DQL editorDISTINCT
selection support for deduplicating query resultsARRAY
of values to the IN
operator./store/write
HTTP API now use the more compact ObjectID
format (previously UUIDv4
).DELETE
statements and automatic tombstone eviction are now generally available on Big Peer"local"
, evaluating in the executing peer’s local timezonev5/store/execute
HTTP API endpoint, which operates with DQL_STRICT_MODE=false
semanticsINSERT
statements is no longer supportedDQL_STRICT_MODE=false
is now the default for CDC pipelines, Big‑Peer‑to‑Big‑Peer subscriptions and Data Bridge filters, reducing the need for manual configuration.WITH PERMISSION
clauses could short‑circuit and omit valid resultsIS NULL
or IS NOT MISSING
, preventing documents from being skippedDELETE
s. This can be enabled on request by contacting Ditto SupportEXPLAIN
to show query plansCAST
function to explicitly cast between typesUSE IDS
for direct document retrieval by IDSIMILAR TO
filter expressionDATE
processing functionsPN_COUNTER
support (APPLY
clause in UPDATE
statement)UNSET
clause in UPDATE
statementsMERGE
now acts as an alias for UPDATE
in the ON ID CONFLICT
clause of an INSERT
statementINSERT
now accepts either DOCUMENTS
or VALUES
as the keyword introducing the list of values to insertLIMIT
, OFFSET
and ORDER BY
for mutating DQL statementsLIKE
DQL operatorobject_keys
and object_values
scalar DQL functionsIS NOT MISSING
predicates on MAP
fieldsNOT
on non-Boolean panics on Ditto Server (#10762)