Comment by 1718627440

3 months ago

> Ideally, it needs to be "from", then arbitrary number of something like `let` statements

Isn't that what a CTE is?

2 comments

1718627440

Not quite. u/cyberax wants scalar bindings, not table-valued bindings.

Something like

  FROM foo
  LET a = (x + y) * z
  SELECT a;

whereas CTEs are... Common Table Expressions.

That was kind of my first thought...