This document outlines functionality in the DQL language that is in active development. This is not an exhaustive list of the features and functionality the Ditto team is tracking concerning DQL and aims to address larger functionality gaps.
COUNT
SUM
MAX
MIN
AVG
GROUP BY
clause is used to group documents based on one or more fields in a query. It allows you to group data together based on common values in specific fields and perform aggregate calculations on those groups.
HAVING
clause is used in conjunction with the GROUP BY
clause to filter the result of a query based on conditions involving aggregate functions. The HAVING
clause allows you to apply filtering conditions to the grouped data in a query.
FROM
terms can be used to refer to multiple collections within a query. When you include multiple FROM
terms, the result is a cross-product of the collections. This results in a larger result set that includes all possible combinations.
DO REPLACE
clause is used to replace a document in a collection if it
already exists, or insert a new document if it does not exist. This is useful
for ensuring that a document will exist in the collection with the specified
data, regardless of whether it already exists or not, instead of utilizing the default merge behavior.
LEFT JOIN
INNER JOIN
CROSS JOIN
RIGHT JOIN
OUTER JOIN
INSERT INTO
statement will support CBOR serialized data.
CBOR data is declared using CBOR
keyword prior to the CBOR object.