Common Table Expressions enable a lot of composability. Using them can look like you're asking the DB to repeat a lot of work, but decent query optimizers elimi

Common Table Expressions enable a lot of composability. Using them can look like you're asking the DB to repeat a lot of work, but decent query optimizers eliminate much of that. https://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/ https://www.craigkerstiens.com/2013/11/18/best-postgres-feat...