Yep, CTEs are a huge boon to structure your SQL - use them where you can.