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
List<OrderByContext> orders = ctx.orderBy();
            OrderByContext endContext = orders.get(orders.size() - 1);
            Source source = source(ctx.ORDER(), endContext);
            List<Order> order = visitList(this, ctx.orderBy(), Order.class);
            if (plan instanceof Limit limit) {
                
                plan = limit.replaceChild(new OrderBy(source, limit.child(), order));
            } else {
                plan = new OrderBy(source, plan, order);
            }
        }
        LimitClauseContext limitClause = ctx.limitClause();
        if (limitClause != null) {
            Token limit = limitClause.limit;
            if (limit != null && limitClause.INTEGER_VALUE() != null) {
                if (plan instanceof Limit) {
                    throw new ParsingException(
                        source(limitClause),
                        "TOP and LIMIT are not allowed in the same query - use one or the other"
                    );
                } else {
                    plan = limit(plan, source(limitClause), limit);
                }
            }
        }
        return plan;
    }
    @Override
    public LogicalPlan visitQuerySpecification(QuerySpecificationContext ctx) {
        LogicalPlan query;