I've been working with Toplink for some time and I believe it will translate JPA queries to SQL.
Also I've worked with joined table queries in jpa (with few thousands records as result) and never
got memory issue.
[Message sent by forum member 'kennethmark' (kennethmark)]
http://forums.java.net/jive/thread.jspa?messageID=356209