Frozen indices are deprecated which makes all the [SQL features supporting frozen indices](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-index-frozen.html) obsolete.

This includes:

* `index_include_frozen` request parameter in the `_sql` endpoint
* `index.include.frozen` (J|O)DBC driver settings
* `SHOW TABLES INCLUDE FROZEN` queries and the `FROZEN INDEX` kind in the corresponding response
* The `FROZEN` modifier in `FROM` clauses (as in `SELECT * FROM FROZEN archive`)

`_search` raises a deprecation warning when frozen indices are being searched with `ignore_throttled=false`. SQL could do the same when the `index_include_frozen` request parameter is set or when the `FROZEN` keyword is used.

Relates to https://github.com/elastic/elasticsearch/issues/70192
x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/parser/LogicalPlanBuilder.java
if (ctx.fromClause() == null) {
            query = new LocalRelation(source(ctx), new SingletonExecutable());
        } else {
            query = plan(ctx.fromClause());
        }
        
        if (ctx.where != null) {
            query = new Filter(source(ctx), query, expression(ctx.where));
        }
        List<NamedExpression> selectTarget = ctx.selectItems().isEmpty()
            ? emptyList()
            : visitList(this, ctx.selectItems().selectItem(), NamedExpression.class);
        
        GroupByContext groupByCtx = ctx.groupBy();
        if (groupByCtx != null) {
            SetQuantifierContext setQualifierContext = groupByCtx.setQuantifier();
            TerminalNode groupByAll = setQualifierContext == null ? null : setQualifierContext.ALL();
            if (groupByAll != null) {
                throw new ParsingException(source(groupByAll), "GROUP BY ALL is not supported");
            }
            List<GroupingElementContext> groupingElement = groupByCtx.groupingElement();
            List<Expression> groupBy = expressions(groupingElement);
            ParserRuleContext endSource = groupingElement.isEmpty() ? groupByCtx : groupingElement.get(groupingElement.size() - 1);
            query = new Aggregate(source(ctx.GROUP(), endSource), query, groupBy, selectTarget);
        } else if (selectTarget.isEmpty() == false) {
            query = new Project(source(ctx.selectItems()), query, selectTarget);
        }
        
        if (ctx.having != null) {
            query = new Having(source(ctx.having), query, expression(ctx.having));