Statements and clauses
EQL queries consist of statements. Statements, in their turn, can contain several types of clauses.
DEFINE and RETURN clauses
specify whether to return the result.
SELECT clauses
specify how to compute attributes that will appear in statement results.
FROM clauses
(optional) specify the source.
JOIN clauses
(optional) allow source record joining.
WHERE clauses
(optional) filter source records.
GROUP/GROUP BY clauses
(optional) specify source record to result record mapping.
HAVING clauses
(optional) filter result records.
ORDER BY clauses
(optional) specify sort criteria.
PAGE clauses
(optional) specify the subset of records to be included in a statement result.