### 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/jdbc/DatabaseMetaDataTestCase.java
* {@link DatabaseMetaData#getProcedures(String, String, String)}.
     */
    public void testGetProcedures() throws Exception {
        try (Connection h2 = LocalH2.anonymousDb(); Connection es = esJdbc()) {
            h2.createStatement().executeUpdate("RUNSCRIPT FROM 'classpath:/setup_mock_metadata_get_procedures.sql'");
            ResultSet expected = h2.createStatement().executeQuery("SELECT * FROM mock");
            assertResultSets(
                expected,
                es.getMetaData()
                    .getProcedures(
                        randomBoolean() ? null : randomAlphaOfLength(5),
                        randomBoolean() ? null : randomAlphaOfLength(5),
                        randomBoolean() ? null : randomAlphaOfLength(5)
                    )
            );
        }
    }
    /**
     * We do not support procedures so we return an empty set for
     * {@link DatabaseMetaData#getProcedureColumns(String, String, String, String)}.
     */
    public void testGetProcedureColumns() throws Exception {
        try (Connection h2 = LocalH2.anonymousDb(); Connection es = esJdbc()) {
            h2.createStatement().executeUpdate("RUNSCRIPT FROM 'classpath:/setup_mock_metadata_get_procedure_columns.sql'");
            ResultSet expected = h2.createStatement().executeQuery("SELECT * FROM mock");
            assertResultSets(
                expected,
                es.getMetaData()
                    .getProcedureColumns(
                        randomBoolean() ? null : randomAlphaOfLength(5),