localhost :) SELECT x, if(x = 3, 1, neighbor(y, -1) * 2 + x) as y FROM a;

SELECT
    x,
    if(x = 3, 1, (neighbor(y, -1) * 2) + x) AS y
FROM a

Query id: 4ef9c2e8-4486-4e17-9971-ebc47f9ad60d


Received exception from server (version 21.2.3):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'y' while processing query: 'SELECT x, if(x = 3, 1, (neighbor(y, -1) * 2) + x) AS y FROM a', required columns: 'x' 'y', maybe you meant:  '['x']' '['x']'. 

0 rows in set. Elapsed: 0.003 sec.

SELECT
    x,
    if(x = 3, 1, (neighbor(y, -1) * 2) + x) AS y
FROM
(
    SELECT
        number AS x,
        number AS y
    FROM numbers(10)
)

Query id: fcf3035b-a7ce-43c2-807b-2af4158a9713

┌─x─┬──y─┐
│ 0 │  0 │
│ 1 │  1 │
│ 2 │  4 │
│ 3 │  1 │
│ 4 │ 10 │
│ 5 │ 13 │
│ 6 │ 16 │
│ 7 │ 19 │
│ 8 │ 22 │
│ 9 │ 25 │
└───┴────┘