Hacker News new | ask | show | jobs
by 1718627440 210 days ago
> Ideally, it needs to be "from", then arbitrary number of something like `let` statements

Isn't that what a CTE is?

2 comments

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...