Y
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
cryptonector
210 days ago
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
.
link
tracker1
210 days ago
That was kind of my first thought...
link
Something like
whereas CTEs are... Common Table Expressions.