I’m currently working in a project that involves a lot of data processing and therefore databases. This means that we often come into contact with SQL at work and have to write an SQL query at least once a day.

Privately, I once came across Common Table Expressions in the course of my GoBlog development and used this knowledge at work and showed it to my colleagues, some of whom didn’t know about it yet. Since then, we use them quite often.

But CTEs are really in most cases more comprehensible than deeply nested subqueries.

Anton Zhiyanov explains these CTEs in a post.