Postgres expert, Bruce Momjian, discusses common table expressions (CTEs) and the ability to allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages.
Webinar video:
Webinar slides: