I've always just abstracted the DB away with objects and lazy-load any 'subqueries' that I might want to have/use/get (or autoload them if necessary).