Patent ID: 8489579

Claim:
A method, implemented in a computer system, comprising: receiving an SQL operation, wherein the SQL operation is configured to be performed on a data set using input data, the data set comprises a plurality of tables, and the plurality of tables comprises a parent table, and a child table; determining a structure of the data set, wherein the determining uses an SQL integration object definition; determining that a parent record of the parent table corresponds to a parent of a child record of the child table, wherein the determination that the parent record of the parent table corresponds to the parent of the child record of the child table is performed in response to determining that a field of the parent record comprises a value of a field of the child record; constructing, using a processor of the computer system, at least one SQL statement conforming to the structure, wherein the constructing the at least one SQL statement comprises using an instance of the SQL integration object definition to identify a data value for an instance of the SQL integration field definition in the input data, and concatenating a clause to a first SQL statement of the at least one SQL statement to select a record from the table, the record having the data value for the column; and executing, using the processor, the at least one SQL statement on the data set, wherein the at least one SQL statement uses the input data, and the executing the at least one SQL statement is performed in accordance with the SQL operation.