https://github.com/NLPchina/elasticsearch-sql

Simple query

http://localhost:9200/_sql?sql=select * from indexName limit 10

SQL to DSL

http://localhost:9200/_sql/_explain?sql=select * from indexName limit 10