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.