If you want real SQL on top of Elasticsearch have a look at <a href="https:&#x2F;&#x2F;crate.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;crate.io&#x2F;</a> (<a href="https:&#x2F;&#x2F;crate.io&#x2F;blog&#x2F;sql-for-elasticsearch&#x2F;" rel="nofollow">https:&#x2F;&#x2F;crate.io&#x2F;blog&#x2F;sql-for-elasticsearch&#x2F;</a>).<p>P.S.: I&#x27;m not affiliated with that company.