Formatting in a Database

A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

• providing, from an application, a request for data in a database, the request including one or more formatting functions to be performed on the data to display a result of the request in a graphical user interface generated by the application;
• executing the formatting functions at the database to restructure the request;
• generating a query of the data in the database based on the restructured request, the query including only data to display in the graphical user interface according to the request;
• returning a result of the query from the database to the application for display in the graphical user interface.

A system comprising:

• at least one programmable processor;
• and
• a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one programmable processor to perform operations comprising:
• provide, from an application, a request for data in a database, the request including one or more formatting functions to be performed on the data to display a result of the request in a graphical user interface generated by the application;
• execute the formatting functions at the database to restructure the request;
• generate a query of the data in the database based on the restructured request, the query including only data to display in the graphical user interface according to the request;
• return a result of the query from the database to the application for display in the graphical user interface.