docs/reference/query-languages/sql.md
Elasticsearch SQL aims to provide a powerful yet lightweight SQL interface to {{es}}.
Elasticsearch SQL is a feature that allows SQL-like queries to be executed in real-time against {{es}}. Whether using the REST interface, command-line or JDBC, any client can use SQL to search and aggregate data natively inside {{es}}. One can think of Elasticsearch SQL as a translator, one that understands both SQL and {{es}} and makes it easy to read and process data in real-time, at scale by leveraging {{es}} capabilities.
Native integration : Elasticsearch SQL is built from the ground up for {{es}}. Each and every query is efficiently executed against the relevant nodes according to the underlying storage.
No external parts : No need for additional hardware, processes, runtimes or libraries to query {{es}}; Elasticsearch SQL eliminates extra moving parts by running inside the {{es}} cluster.
Lightweight and efficient : Elasticsearch SQL does not abstract {{es}} and its search capabilities - on the contrary, it embraces and exposes SQL to allow proper full-text search, in real-time, in the same declarative, succinct fashion.
The following chapters aim to cover everything from usage, to syntax and drivers. Experienced users might want to jump directly to the list of SQL commands and functions.
Getting started : Start using SQL right away in {{es}}.
Concepts and terminology : Language conventions across SQL and {{es}}.
Security : Secure Elasticsearch SQL and {{es}}.
REST API : Execute SQL in JSON format over REST.
Translate API : Translate SQL in JSON format to {{es}} native query.
JDBC : JDBC driver for {{es}}.
ODBC : ODBC driver for {{es}}.
Client Applications : Setup various SQL/BI tools with Elasticsearch SQL.
SQL Language : Overview of the Elasticsearch SQL language, such as supported data types, commands and syntax.
Functions and Operators : List of functions and operators supported.
Limitations : Elasticsearch SQL current limitations.