I was just wondering if it is possible to convert SQL join queries to their DSL equivalent? Formerly in OpenDistro 1.9, query explanation used to return the DSL equivalent. Later versions however stopped doing that. Any advice?
One key thing about DSL and (_search) is that I can mix search, agg and highlight all in one request. I am not sure if that is possible in SQL.