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
request -> request.filter(
                randomValueOtherThan(
                    request.filter(),
                    () -> request.filter() == null ? randomFilter(random()) : randomFilterOrNull(random())
                )
            ),
            request -> request.columnar(randomValueOtherThan(request.columnar(), ESTestCase::randomBoolean)),
            request -> request.cursor(randomValueOtherThan(request.cursor(), SqlQueryResponseTests::randomStringCursor)),
            request -> request.waitForCompletionTimeout(randomValueOtherThan(request.waitForCompletionTimeout(), this::randomTV)),
            request -> request.keepOnCompletion(randomValueOtherThan(request.keepOnCompletion(), ESTestCase::randomBoolean)),
            request -> request.keepAlive(randomValueOtherThan(request.keepAlive(), () -> randomTVGreaterThan(MIN_KEEP_ALIVE)))
        );
        TestSqlQueryRequest newRequest = new TestSqlQueryRequest(
            instance.query(),
            instance.params(),
            instance.filter(),
            instance.runtimeMappings(),
            instance.zoneId(),
            instance.catalog(),
            instance.fetchSize(),
            instance.requestTimeout(),
            instance.pageTimeout(),
            instance.columnar(),
            instance.cursor(),
            instance.requestInfo(),
            instance.fieldMultiValueLeniency(),
            instance.indexIncludeFrozen(),
            instance.waitForCompletionTimeout(),
            instance.keepOnCompletion(),
            instance.keepAlive()