Query Elasticsearch Indices with SQL
Tap into Elasticsearch with a familiar syntax
Elasticsearch has the speed, scale, and flexibility your data needs and it speaks SQL. Use traditional database syntax to unlock non-traditional performance, like full text search across petabytes of data with real-time results.
Source: Elasticsearch SQL: Query Elasticsearch Indices with SQL - Elastic
Seems cool in concept. Never really liked the JSON queries.