I'm not really sure what your question is. Cayenne will fetch all of the fields that are modeled and turn them into objects. And you can add prefetching paths to your SelectQuery to pre-fetch the related objects, otherwise they will be loaded when accessed. If you want to write your own SQL and get a HashMap of the data you can use SQLTemplate instead of SelectQuery.
John
