EQL is, in many ways, similar to SQL, but has some marked differences as well.
DEFINE
or RETURN
clause, which, like a SQL common table expression (or CTE), defines a temporary result set. The following differences apply, however:
RETURN
is both a CTE and a normal statement (one that produces results).FROM
clause, either directly or indirectly.SELECT
, FROM
, WHERE
, HAVING
, GROUP BY
, and ORDER BY
are all like SQL, with the following caveats:
SELECT
statements, AS
aliasing is optional when selecting an attribute verbatim; statements using expressions require an AS
alias. Aliasing is optional in SQL.GROUP BY
implies SELECT
. That is, grouping attributes are always included in statement results, whether or not they are explicitly selected.MEMBERS
extension in a GROUP BY
clause, a single record can participate in multiple groups.WHERE
can be applied to an aggregation expression.PAGE
works in the same way as many common vendor extensions to SQL.JOIN
expression's Boolean join condition must be contained within parentheses. This is not necessary in SQL.SELECT
statements only. It does not support other DML statements, such as INSERT
or DELETE
, nor does it support DDL, DCL, or TCL statements.