The only down side I have found with derived tables is that they are memory intensive.

This becomes an issue if you have an application that runs complicated queries for a couple of hundred users.