For me the key point was this:<p><i>Of course this can be resolved with the use of intermediate or temporary tables.</i><p>Other than waving his hands he didn't really give an downsides to this approach.  And in my past experience intermediate tables are a great way to go.