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/sql-action/src/test/java/org/elasticsearch/xpack/sql/action/SqlQueryRequestTests.java
);
        mutator.accept(newRequest);
        return newRequest;
    }
    private AbstractSqlQueryRequest mutateRequestInfo(SqlQueryRequest oldRequest, SqlQueryRequest newRequest) {
        RequestInfo requestInfo = randomValueOtherThan(newRequest.requestInfo(), this::randomRequestInfo);
        newRequest.requestInfo(requestInfo);
        if (Mode.isDriver(oldRequest.requestInfo().mode()) && Mode.isDriver(requestInfo.mode()) == false) {
            for (SqlTypedParamValue param : oldRequest.params()) {
                param.hasExplicitType(false);
            }
        }
        if (Mode.isDriver(oldRequest.requestInfo().mode()) == false && Mode.isDriver(requestInfo.mode())) {
            for (SqlTypedParamValue param : oldRequest.params()) {
                param.hasExplicitType(true);
            }
        }
        return newRequest;
    }
    public void testTimeZoneNullException() {
        final SqlQueryRequest sqlQueryRequest = createTestInstance();
        IllegalArgumentException e = expectThrows(IllegalArgumentException.class, () -> sqlQueryRequest.zoneId(null));
        assertEquals("time zone may not be null.", e.getMessage());
    }
    private RequestInfo randomRequestInfo() {
        return new RequestInfo(randomFrom(Mode.values()), randomFrom(randomFrom(CLIENT_IDS), requestInfo.clientId()));
    }
    private TimeValue randomTV() {
        return TimeValue.parseTimeValue(randomTimeValue(), null, "test");
    }