Elastic Sql

NoSQL databases generally provide query interfaces of their own, but many also support SQL or provide SQL-like query languages. ElasticSearch (from v6.3) has been supporting SQL queries - this is done by passing a GET request to “/_xpack/sql” with a JSON query body containing the SQL query for the field “query”. This can be mixed with ElasticSearch native query filtering. In addition, sending the query to “_xpack/sql/translate” provides the ElasticSearch native query equivalent.