Have you checked out Crate.IO? https://crate.io/overview as an "SQL for Elasticsearch" option.