Generating applications based on data definition language (DDL) query view and application page template

A method and system for generating an application has been described. A request is received to generate the application. Based on the received request, a Data Definition Language (DDL) query view defined for the application is executed to obtain a query view and a data transfer service. Next data is retrieved from the database based on the query view and the data transfer service. An application page template including a user interface (UI) related elements of the application is then generated based on the received request. The application page template and the retrieved data is then bound to generate a plurality of application pages of the application.