I just happened across an article on Hibernate which talks about lazy attributes. (A recent addition, I think.) This essentially allows you to flag an attribute/column as lazy and it'll be excluded from the original SELECT query, but if you call the getter it will then fetch it in. This is convenient for BLOB-type data that might happen to be in a main table with other attributes (such as MIME types, file sizes, file names, etc).
Thoughts on maybe adding this feature to Cayenne? I can imagine there'd be a "Lazy" column in Cayenne Modeler for the attributes to control/identify them. Thanks, mrg