Ah yes. Right. Scott was talking about an object-relational mapper. Which means that the overall example is going to involve a lot of OOP.
It was not the mapper that allowed him to shorten his queries. Again, just because something exists does not necessarily mean it is better.
Plus, how come you cannot use your techniques to shorten challenge #6?