### 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/BaseRestSqlTestCase.java
%s
                """.formatted(doc));
        }
        request.setJsonEntity(bulk.toString());
        provisioningClient().performRequest(request);
    }
    protected void deleteTestIndex() throws IOException {
        deleteIndex(TEST_INDEX);
    }
    protected static void deleteIndex(String name) throws IOException {
        deleteIndex(provisioningClient(), name);
    }
    public static RequestObjectBuilder query(String query) {
        return RequestObjectBuilder.query(query);
    }
    public static RequestObjectBuilder cursor(String query) {
        return RequestObjectBuilder.cursor(query);
    }
    public static String randomMode() {
        return randomFrom(StringUtils.EMPTY, Mode.JDBC.toString(), Mode.PLAIN.toString());
    }
    /**
     * JSON parser returns floating point numbers as Doubles, while CBOR as their actual type.
     * To have the tests compare the correct data type, the floating point numbers types should be passed accordingly, to the comparators.
     */
    public static Number xContentDependentFloatingNumberValue(String mode, Number value) {
        Mode m = Mode.fromString(mode);
        
        if (Mode.isDedicatedClient(m)) {
            return value;