Using the approach I outlined in the screencast (a read-only view object based on a SQL statement) the query can be of arbitrary complexity, so long as it parses as a valid SQL statement.