Projection expressions are allowed to reference preceding aliases from the same projection. In case of projection alias clashing with a column name from the base SQL, the latter is preferred. E.g. this is the expected output:

> CREATE TABLE test (x integer);
> INSERT INTO test VALUES (1), (2), (3);
> select x + 10 x, x - 5 from test;
┌───────┬─────────┐
│   x   │ (x - 5) │
│ int32 │  int32  │
├───────┼─────────┤
│    11 │      -4 │
│    12 │      -3 │
│    13 │      -2 │
└───────┴─────────┘
>

Memoizable functions

There are two new methods on Function interface:

Function.shouldMemoize()
Function.memoizeI()

The immediate beneficiary is the family of rnd_ functions, which execution is now stabilised per data row.

todo

Parser/Optimiser support for

• select f(a) i, i + 1 from ... - vanilla
• select f(a) (i), f(i) (y), sum(y) from ... group-by key and value
• select f(a) i, f(i) y, sum(y) from tab sample by 1d - sample by
• select f(a) i, lag(i) over from ... - window functions

Generator support for

• vanilla
• window