Personally I find SQL much easier to read. In a product where you might allow users to write queries it is a much more pleasant UX experience to write and read

Personally I find SQL much easier to read. In a product where you might allow users to write queries it is a much more pleasant UX experience to write and read SQL than it would be to do so for ES queries. It isn't a problem to understand how to build an ES query object but an ES query object is pretty terrible to read IMO.