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
randomTV(),
            randomBoolean(),
            randomAlphaOfLength(10),
            requestInfo,
            randomBoolean(),
            randomBoolean(),
            randomTV(),
            randomBoolean(),
            randomTVGreaterThan(MIN_KEEP_ALIVE)
        );
    }
    @Override
    protected Writeable.Reader<TestSqlQueryRequest> instanceReader() {
        return TestSqlQueryRequest::new;
    }
    @Override
    protected TestSqlQueryRequest doParseInstance(XContentParser parser) {
        return SqlTestUtils.clone(TestSqlQueryRequest.fromXContent(parser), instanceReader(), getNamedWriteableRegistry());
    }
    @Override
    protected TestSqlQueryRequest mutateInstance(TestSqlQueryRequest instance) {
        @SuppressWarnings("unchecked")
        Consumer<SqlQueryRequest> mutator = randomFrom(
            request -> mutateRequestInfo(instance, request),
            request -> request.query(randomValueOtherThan(request.query(), () -> randomAlphaOfLength(5))),
            request -> request.params(randomValueOtherThan(request.params(), this::randomParameters)),
            request -> request.zoneId(randomValueOtherThan(request.zoneId(), ESTestCase::randomZone)),
            request -> request.catalog(randomValueOtherThan(request.catalog(), () -> randomAlphaOfLength(10))),
            request -> request.fetchSize(randomValueOtherThan(request.fetchSize(), () -> between(1, Integer.MAX_VALUE))),
            request -> request.requestTimeout(randomValueOtherThan(request.requestTimeout(), this::randomTV)),