GeezerVison

What I ran: ./build.sh (passes), then mvn test -Dtest='LambdaClosureTests,ArrayFunctionsTests' against the pinned Calcite. Result: 70 tests, 3 errors, all in LambdaClosureTests (testCorrelatedSubquery, testCorrelatedSubquerySameType returns wrong rows, testBodyRestrictions). They depend on the unmerged Calcite change; see the inline comment. ArrayFunctionsTests passes. I also ran some extra QA cases:

• bug (medium): a lambda that captures a column in a window PARTITION BY/ORDER BY leaves a RexOver inside a LogicalProject, and the user gets a misleading "COUNT not yet implemented" error. Please either support it or reject it with a clear message, and document it next to the other restrictions in grammar.md.
• missing (medium): no tests cover window clauses or HAVING with captured columns. Suggested additions to LambdaClosureTests:

@Test
public void testHaving() {
    var ccs = this.getCCS(TABLES + """
            CREATE VIEW V AS SELECT x FROM T GROUP BY x
            HAVING ARRAY_EXISTS(ARRAY_AGG(x), e -> e = x + 0);""");
    ccs.stepWeightOne(DATA, " x\n---\n 10\n 2");
}

@Test
public void testWindowPartition() {
    var ccs = this.getCCS("""
            CREATE TABLE T(a INT ARRAY, x INT, ts INT);
            CREATE VIEW V AS SELECT x, SUM(ts) OVER
              (PARTITION BY ARRAY_EXISTS(a, e -> e = x) ORDER BY ts) AS s FROM T;""");
    ccs.stepWeightOne("INSERT INTO T VALUES(ARRAY[1], 1, 1), (ARRAY[3], 2, 2), (ARRAY[3], 3, 3);",
            " x | s\n-------\n 1 | 1\n 2 | 2\n 3 | 4");
}

Docs and tests are otherwise in place. Not mergeable until the Calcite pin includes apache/calcite#5409.