Are there any plans or working notes on adding support to Cayenne for OUTER JOINs? I didn't find a CAY-xxx feature request.
Outer joins would be nice, though its complex because of the differences in syntax... plus the whole issue that you are loading a potentially incomplete object graph. For example, your join syntax and qualifier could limit the toMany relationships arbitrarily, leaving Cayenne to guess if it got the whole relationship or not. There are already similar prefetch bugs to this, and they would have to be fixed before OJ's could be tackled. But yeah... who doesn't want it :) On the other hand, most developers abuse the outer join, creating confusing queries that don't save as many CPU cycles as you would really think. I think you might find that a regular prefetch could handle your problem just as well. If you really need the performance (or the special relationship fetching), use a SQLTemplate.
Not for the faint of heart to add to Cayenne I take it.
Not really :) Cris
