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.
Yeah. That was one of the reasons I wrote this.
The difference between using simple and/or queries is pretty big at first. There's definitely some nuance before "jumping onboard" ES, at least from my perspective.