Have a look at PRQL (www.prql-lang.org)! That's exactly what it's aiming to provide.
Re:Elasticsearch SQL
by anirudha81 on Tuesday October 25, 2022 @02:07PM
(#33334131)
we looked at it recently, alas; we start the effort much before prql came up
https://github.com/opensearch-project/sql/blob/2.x/docs/user...