SQL: Multiple indices pattern

[costin]

While SQL supports multiple indices, ES indices patterns is not, in particular index exclusion or the date expression.
To some degree this is related to #31837, as it involves the validation and discovery of the indices.

[elasticmachine]

Pinging @elastic/es-search-aggs