A small blogpost about a nice feature of Snowflake. I stumbled upon an interesting difference between SQL Server and Snowflake. It is about using an alias in the same query. I've never seen this before, but i'm biased to Microsoft of course.
So here is the thing. Suppose you have the following query :
SELECT 1 AS TEST,
TEST + 1 AS TEST2