### 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
}
    private void executeQueryWithNextPage(String format, String expectedHeader, String expectedLineFormat) throws IOException {
        int size = 20;
        String[] docs = new String[size];
        for (int i = 0; i < size; i++) {
            docs[i] = """
                {"text":"text%s", "number":%s}
                """.formatted(i, i);
        }
        index(docs);
        String optionalGroupBy = randomFrom("", " GROUP BY text, number, sum");
        RequestObjectBuilder request = query(
            "SELECT text, number, number + 5 AS sum FROM " + indexPattern("test") + optionalGroupBy + " ORDER BY number"
        ).fetchSize(2);
        String cursor = null;
        for (int i = 0; i <= size; i += 2) {
            Tuple<String, String> response;
            if (i == 0) {
                response = runSqlAsText(request, format);
            } else {
                response = runSqlAsText(cursor(cursor), format);
            }
            StringBuilder expected = new StringBuilder();
            if (i == 0) {
                expected.append(expectedHeader);
                if (format.equals("text/plain")) {
                    expected.append("---------------+---------------+---------------\n");
                }
            }
            cursor = response.v2();