Amazon Redshift now supports new SQL functionalities including ROLLUP, CUBE, and GROUPING SETS, to simplify building multi-dimensional analytics applications. ROLLUP, CUBE, and GROUPING SETS simplifies data warehouse migrations by offering the commonly used syntax across databases.