1. A computer-implemented method for processing data, comprising: executing an application that accesses a data model including one or more tables, wherein the one or more tables comprise a set of scalar fields and a derived field associated with at least one of a summary, a formula, and a lookup, and wherein the derived field comprises identifying information of at least one related field or table in the data model or in a relational database; storing the scalar fields in the relational database; using the data model to generate a first query for the relational database to obtain data associated with the derived field using one or more joins of one or more of the scalar fields based at least in part on the identifying information; and enabling use of the first query to provide the data to a user during use of the application by the user.