Object relational mapping with a single database query

A method performed by one or more computers, the method comprising:

• receiving a request to populate a software object with values from a plurality of tables represented in a graph, the plurality of tables stored in a relational database maintained by a database management system, each table comprising one or more respective tuples of values;
• generating a single query statement that, when executed by the database management system, causes the database management system to retrieve the values from the plurality of tables as a result set having a plurality of rows of data from each of the plurality of tables, wherein between a parent table and a child table in the graph, the result set includes a row having parent values from the parent table and child values from one row of the child table;
• querying the relational database using the single query statement to obtain the result set;
• and
• populating the software object with one or more values of the result set.

One or more non-transitory computer storage media encoded with computer program instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

• receiving a request to populate a software object with values from a plurality of tables represented in a graph, the plurality of tables stored in a relational database maintained by a database management system, each table comprising one or more respective tuples of values;
• generating a single query statement that, when executed by the database management system, causes the database management system to retrieve the values from the plurality of tables as a result set having a plurality of rows of data from each of the plurality of tables, wherein between a parent table and a child table in the graph, the result set includes a row having parent values from the parent table and child values from one row of the child table;
• querying the relational database using the single query statement to obtain the result set;
• and
• populating the software object with one or more values of the result set.