OP here, completely agreed. I have a separate post from some years back about CTEs specifically around readability. While they can make things a bit long and ca

OP here, completely agreed. I have a separate post from some years back about CTEs specifically around readability. While they can make things a bit long and can be an optimization fence in Postgres the building blocks and readability in my eyes tends to win out over those things pretty often - http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/ http://www.craigkerstiens.com/2013/11/18/best-postgres-featu...