High-level AQL operations

High-level operations are the core language constructs of the query language

• FOR: Iterate over a collection or View, all elements of an array or traverse a graph

• RETURN: Produce the result of a query.

• FILTER: Restrict the results to elements that match arbitrary logical conditions.

• SEARCH: Query an arangosearch or search-alias View.

• SORT: Force a sort of the array of already produced intermediate results.

• LIMIT: Reduce the number of elements in the result to at most the specified number, optionally skip elements (pagination).

• LET: Assign an arbitrary value to a variable.

• COLLECT: Group an array by one or multiple group criteria. Can also count and aggregate.

• WINDOW: Perform aggregations over related rows.

• REMOVE: Remove documents from a collection.

• UPDATE: Partially update documents in a collection.

• REPLACE: Completely replace documents in a collection.

• INSERT: Insert new documents into a collection.

• UPSERT: Update/replace an existing document, or create it in the case it does not exist.

• WITH: Specify collections used in a query (at query begin only).