They've been around quite a long time, but yeah it seems like only SQL89 gets taught. Window Functions and CTEs are both major force multipliers in the languag

They've been around quite a long time, but yeah it seems like only SQL89 gets taught. Window Functions and CTEs are both major force multipliers in the language, so I always encourage folks to go learn them.