I honestly do not care about the efficiency of my SQL. The database is
by far the fastest component. I do not think OJB can really optimize
a simple SELECT foo, bar from BLA; statement. There's just nothing to optimize!
You can always optimize it away. That is, don't do the query at all if you have cached the data. Since any serious ORM solution will give you declarative and transparent support for caching, this alone is a big win in some situations, IMHO.
Ugo
