Developers coming from SQL community to play around with No-SQL systems like elasticsearch, building up queries is something of an issue they constantly face. Simple queries should be fine to deal with but complex queries are real challenging tasks for many to deal in with.
A good news / sigh of relief for developers coming from SQL platform. There is a group of developers who constantly work around on building up simpler solution for providing SQL Query environment over Elasticsearch. It is a plugin which can be downloaded from the following link.
Though this comes in real handy with great advantage, there are limitations to the querying system in here and also, this have to be installed in as plugin inside elasticsearch. Hence, this will be fruitful for developers who have their own server where elasticsearch will be deployed. PLEASE TAKE A NOTE. Do not involve in developing the application / site using this plugin if you are planning to take in elasticsearch as an service.