How to safely use WITH in Postgres

Common Table Expressions (CTEs) can be very powerful, but are generally misunderstood and frequently abused. This talk will explain how CTEs actually work, the best way to use them, and how to understand those confusing recursive CTEs.