Elasticsearch SQL language

SQL stands for Structured Query Language, a programming language that is used for the following purposes:

• Defining data (such as create, alter, and drop commands in DDL)
• Manipulating data (such as insert, update, and delete in DML)
• Resolving queries (such as select, describe, and show in DQL)
• Controlling data access (such as grant and revoke in DCL)
• Dealing with the transaction (such as commit and rollback in TCL) for relational databases

Elasticsearch SQL does not have a DCL (Data Control Language) and TCL (Transactional Control Language) in its current version. To understand this language better, we will follow six aspects, including keywords, data types, operators, functions, and lexical structure, to study it.

Reserved keywords

...