CTE was a game changer for regular business people I work with being able to express what they want in SQL.

SQL is still dreadful, apart from all the alternatives.