Hi, In my project i am transforming user query to SQL statement for dynamic search.
As _xpack/sql support to execute sql statement, i can directly or with minimum changes use my existing tested functionality with elastic search.
Wanted to know that is _xpack allow to search in Alias to search from all indexes? is their any way to achieve this using _xpack/sql?
"query": "SELECT * FROM [Alias Name]"