Conditional selection of compound fields from structured objects

An apparatus comprising:

• a data storage for a database, the database including a plurality of structured objects, the apparatus to generate an application programming interface (API) type for the database, the API type including types of fields of a plurality of structured objects stored in the database, wherein the database includes one or more compound fields, each compound field includes a plurality of fields for each of a plurality of structured objects stored in a database, and the plurality of fields include one or more flexible fields that have a different field type for a first structured object and a second structured object;
• a system interface to receive queries regarding the database;
• and
• a processor to process queries, wherein upon the apparatus receiving a query from a user to select a compound field of the database from any structured object that satisfies a condition specified in the query, the processor is to:
• determine whether any structured object of the plurality of structured objects stored in the database satisfies the condition;
• upon a determination that one or more structured objects of the plurality of structured objects satisfy the condition, automatically generate a plurality of program objects or codes based at least in part on one or more field types that are within the one or more structured objects, wherein generating the plurality of program objects or codes includes generating a set of one more program objects or codes that correspond to the plurality of fields in the compound field associated with each of the one or more structured objects that satisfy the condition, each generated program object or code being structured to enable the user to access data in a field that is associated with the program object or code according to the values for the fields in each of the one or more structured objects;
• and
• provide a result of the query to the user, the result of the query including:
• data from the one or more structured objects that are determined to satisfy the condition specified in the query, and
• the plurality of program objects or codes generated for the one or more structured objects to enable the user to access the data provided to the user from the one or more structured objects.

A non-transitory computer-readable storage medium having stored thereon data representing sequences of instructions that, when executed by a processor, cause the processor to perform operations comprising:

• generating an application programming interface (API) type for a database of a database system, the API type including types of fields of a plurality of structured objects stored in the database, wherein the database includes one or more compound fields, each compound field includes a plurality of fields for each of a plurality of structured objects stored in a database, and the plurality of fields include one or more flexible fields that have a different field type for a first structured object and a second structured object;
• receiving a query from a user at the database system to select a compound field of the database from any structured object that satisfies a condition specified in the query;
• determining by the database system whether any structured object of the plurality of structured objects stored in the database satisfies the condition;
• upon a determination that one or more structured objects of the plurality of structured objects satisfy the condition, automatically generating by the database system a plurality of program objects or codes based at least in part on one or more field types that are within the one or more structured objects, wherein generating the plurality of program objects or codes includes generating a set of one or more program objects or codes that correspond to the plurality of fields in the compound field associated with each of the one or more structured objects that satisfy the condition, each generated program object or code being structured to enable the user to access data in a field that is associated with the program object or code according to the respective values for the fields in each of the one or more structured objects;
• and
• providing a result of the query to the user, the result of the query including
• data from the one or more structured objects that are determined to satisfy the condition specified in the query, and
• the plurality of program objects or codes generated for the one or more structured objects to enable the user to access the data provided to the user from the one or more structured objects.