5 reasons to use SQL Common Table Expressions (WITH clause)

After years of working with SQL and optimizing hundreds of poorly written queries, I decided to write this post to encourage use of what I found to be one of the SQL’s most underappreciated features – Common Table Expressions, often known as ‘WITH clause’.