Hello @Clinton_Gormley
I know that your post is old but the following answer could be useful for someone else because this topic was the top Google answer. I was searching the same thing than you and found out this gem : https://github.com/NLPchina/elasticsearch-sql/issues/156. I don't know if it could solve someone else problem or even how you solved yours but it's still a good alternative.
An announcement has even been released here : Announcment: elasticsearch-sql release version 1.2.
Long live ES.