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
@Before
    public void setup() {
        requestInfo = new RequestInfo(randomFrom(Mode.values()), randomFrom(randomFrom(CLIENT_IDS), randomAlphaOfLengthBetween(10, 20)));
    }
    @Override
    protected TestSqlQueryRequest createXContextTestInstance(XContentType xContentType) {
        SqlTestUtils.assumeXContentJsonOrCbor(xContentType);
        return super.createXContextTestInstance(xContentType);
    }
    @Override
    protected NamedWriteableRegistry getNamedWriteableRegistry() {
        SearchModule searchModule = new SearchModule(Settings.EMPTY, Collections.emptyList());
        return new NamedWriteableRegistry(searchModule.getNamedWriteables());
    }
    @Override
    protected NamedXContentRegistry xContentRegistry() {
        SearchModule searchModule = new SearchModule(Settings.EMPTY, Collections.emptyList());
        return new NamedXContentRegistry(searchModule.getNamedXContents());
    }
    @Override
    protected TestSqlQueryRequest createTestInstance() {
        return new TestSqlQueryRequest(
            randomAlphaOfLength(10),
            randomParameters(),
            SqlTestUtils.randomFilterOrNull(random()),
            randomRuntimeMappings(),
            randomZone(),
            randomAlphaOfLength(10),
            between(1, Integer.MAX_VALUE),
            randomTV(),