For me the key point was this:

Of course this can be resolved with the use of intermediate or temporary tables.

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.