For dialects such as BigQuery, JDBC adapter translates a correlated UNNEST query to invalid SQL

@Test void testUnnestCorrelateBrokenInSomeDialects() {
    final String sql = "SELECT did + 1\n"
        + "FROM \"department\", UNNEST(array[\"department_id\", 1]) as t(did)";

    final String expected = "SELECT \"$cor0\".\"DID\" + 1\n"
        + "FROM (SELECT \"department_id\", \"department_description\", ARRAY[\"department_id\", 1] AS \"$f2\"\n"
        + "FROM \"foodmart\".\"department\") AS \"$cor0\",\n"
        + "LATERAL (SELECT \"col_0\" AS \"DID\"\n"
        + "FROM UNNEST (SELECT \"$cor0\".\"$f2\"\n"
        + "FROM (VALUES (0)) AS \"t\" (\"ZERO\")) AS \"t1\" (\"col_0\")) AS \"t2\"";
    sql(sql).ok(expected);

    for (DatabaseProduct databaseProduct : DatabaseProduct.values()) {
      final SqlDialect sqlDialect = databaseProduct.getDialect();
      try {
        sql(sql).dialect(sqlDialect).exec();
      } catch (UnsupportedOperationException e) {
        System.out.println("sqlDialect throws: " + sqlDialect.getClass().getSimpleName());
        e.printStackTrace();
      }
    }
  }