1. A method for accessing in a database using container managed persistence enterprise Java beans (EJBs), wherein each instance of the container managed persistence enterprise Java bean object represents a row of data in the database, the method comprising the steps of: (a) receiving a single EJB select method at a container managed persistence EJB object to access data of one or more container managed persistence EJB objects; (b) translating an EJB query language (EJBQL) query of said single EJB select method into a target language query of said database wherein said EJBQL query comprises a WHERE clause, wherein said WHERE clause comprises a sub EJBQL query; (c) retrieving data from said database using said target language query; (d) saving said data as a result set object containing the retrieved data in response to the target language query; and (e) allowing access to said result set object to retrieve said data.