Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on PRQL – A proposal for a better SQL. Parent comment
The DB we use supports those, I just learned about them too late so keep forgetting they exist :(
> It would really help in SQL if you could refer to column aliases so you don't have to repeat the expression.
The DB we use supports that, so in your CTE you could write
AND gross_cost > 0
There are no comments on this comment yet.
The DB we use supports those, I just learned about them too late so keep forgetting they exist :(
> It would really help in SQL if you could refer to column aliases so you don't have to repeat the expression.
The DB we use supports that, so in your CTE you could write
We do that all the time, which will be a pain now that we're migrating to a different DB server which doesn't.