Over the course of working on an array of applications using Elasticsearch I have developed a new respect for SQL. ES's JSON query language is a royal pain in the ass. It has a new-ish SQL-like query language now but that didn't come along until I'd sunk too many hours into the old one.