Redshift lateral column alias, also known as derived column, is created from previously computed columns in the same SELECT statement. These columns are virtual and not stored in the table; their values are recalculated each time they are used in a query. Many PostgreSQL databases, like Netezza, support lateral column aliases. Recently, Redshift has also started supporting this feature. In this post, let’s explore this new capability. Page Content Introduction Benefits of Using Lateral Column Alias in Redshift How Lateral Column Alias Works in Redshift (with Example) Lateral Column Alias…