DQL is designed to simplify data interactions in your applications, providing a consistent and intuitive interface for querying and manipulating data. Whether you’re a developer looking to streamline your backend operations or an engineer focused on optimizing data flow, DQL is tailored to meet your needs.

DQL Quick Reference

SELECT

DQL
SELECT *
FROM your_collection_name
[WHERE condition]
[ORDER BY orderby_expression_1, orderby_expression_2, ... [ASC|DESC]]
[LIMIT limit_value]
[OFFSET number_of_documents_to_skip]

INSERT

DQL
INSERT INTO your_collection_name
DOCUMENTS ([document1]),([document2]), ([document3]), ...
[ON ID CONFLICT [FAIL | DO NOTHING | DO UPDATE]]

UPDATE

DQL

UPDATE your_collection_name
SET field1 = value1, field2 -> [mutator], ...
WHERE [condition]

EVICT

DQL
EVICT FROM your_collection_name
WHERE [condition]

To learn the intricacies of read-and-write operations, see CREATE, READ, UPDATE, and DELETE.

Was this page helpful?