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.setQuantifier() != null && ctx.setQuantifier().DISTINCT() != null) {
            query = new Distinct(source(ctx.setQuantifier()), query);
        }
        
        SqlBaseParser.TopClauseContext topClauseContext = ctx.topClause();
        if (topClauseContext != null && topClauseContext.top != null && topClauseContext.INTEGER_VALUE() != null) {
            query = limit(query, source(topClauseContext), topClauseContext.top);
        }
        return query;
    }
    @Override
    public LogicalPlan visitFromClause(FromClauseContext ctx) {
        
        List<LogicalPlan> plans = plans(ctx.relation());
        LogicalPlan plan = plans.stream().reduce((left, right) -> new Join(source(ctx), left, right, Join.JoinType.IMPLICIT, null)).get();
        
        if (ctx.pivotClause() != null) {
            PivotClauseContext pivotClause = ctx.pivotClause();
            UnresolvedAttribute column = new UnresolvedAttribute(source(pivotClause.column), visitQualifiedName(pivotClause.column));
            List<NamedExpression> values = namedValues(pivotClause.aggs);
            if (values.size() > 1) {
                throw new ParsingException(
                    source(pivotClause.aggs),
                    "PIVOT currently supports only one aggregation, found [{}]",
                    values.size()
                );
            }
            plan = new Pivot(source(pivotClause), plan, column, namedValues(pivotClause.vals), namedValues(pivotClause.aggs));
        }