### Description

This is to investigate what we could do to support the data streams in SQL. The backing indices can be queried already, but to address them similarly as they're queried over QDSL one would need to construct a pattern learned out of band and not through SQL metadata discovery mechanisms.
x-pack/plugin/sql/qa/server/src/main/java/org/elasticsearch/xpack/sql/qa/rest/RestSqlTestCase.java
.mapToObj(i -> String.format(Locale.ROOT, "\"field%d\": %d", i, i))
            .collect(Collectors.joining(","));
        index("{" + doc + "}");
        String mode = randomMode();
        Map<String, Object> resp = toMap(runSql(query("SHOW COLUMNS FROM " + indexPattern("test")).fetchSize(1).mode(mode)), mode);
        
        assertThat(resp.get("cursor").toString().length(), lessThan(5000));
    }
    public void testFetchAllPagesSearchHitCursorTxt() throws IOException {
        testFetchAllPagesSearchHitCursor("text/plain");
    }
    public void testFetchAllPagesSearchHitCursorCsv() throws IOException {
        testFetchAllPagesSearchHitCursor("text/csv");
    }
    public void testFetchAllPagesSearchHitCursorTsv() throws IOException {
        testFetchAllPagesSearchHitCursor("text/tab-separated-values");
    }
    public void testFetchAllPagesSearchHitCursor(String format) throws IOException {
        int size = randomIntBetween(4, 20);
        int pageSize = randomIntBetween(1, size + 1);
        List<String> texts = IntStream.range(0, size).mapToObj(i -> String.format(Locale.ROOT, "text%02d", i)).toList();
        index(texts.stream().map(t -> "{\"field\": \"" + t + "\"}").toArray(String[]::new));
        testFetchAllPages(format, "SELECT field FROM " + indexPattern("test") + " ORDER BY field", texts, pageSize, size % pageSize == 0);
    }
    /**
     * Special case of `testFetchAllPagesSearchHitCursorTxt` covering https:github.com/elastic/elasticsearch/issues/83788.
     */
    public void testFetchAllPagesSearchHitCursorWithNonFullLastPageTxt() throws IOException {
        int size = randomIntBetween(4, 20);
        int pageSize = size / 2 + 1;