"...instead of trying to map "tables" to objects, map queries to objects..." Brilliant! My solution to this problem using Propel was to make fake objects that

"...instead of trying to map "tables" to objects, map queries to objects..." Brilliant! My solution to this problem using Propel was to make fake objects that map to views rather than tables. It's worked out splendidly so far. I'm not sure what performance is going to be like in the long term, but it sure beats the O(n) queries that were written before I got there.