WITH and CTEs go some way to help with this, and the majority of queries are a lot better for that.