Postgres users love Common Table Expressions (CTEs) because they make complex SQL easy to read, create, edit, and reuse. Simplicity – CTEs let you break a query into smaller logical chunks, with subqueries defined at the top of the query. It is almost like giving a query book chapters. Build in parts – Since you can test each part of a CTE as its own query, you can build the query in parts that have been individually tested. You can also comment out parts of a CTE for testing and debugging. Reuse – You can reference the same CTE multiple times in a query, which saves repeating logic.