3 ms·

There is a bug for that and it looks someone is even working on it. https://github.com/duckdb/duckdb/issues/1547 https://github.com/duckdb/duckdb/issues/1547

• karmakaze 4y ago
  There's also no need to make it left to right usage, as long as it's acyclic: select y-2 as x, 3 as y, y/x as z;
  • sonthonax 4y ago
    Would this be compiled into a graph of subqueries and window statements?
    • karmakaze 4y ago
      I'm not following, the original could be written as select x + 2 as y, 1 as x, y/x as z; with the same column values in a different order. Order of arguments shouldn't matter is all I was saying.