1. A method for authoring an updated database query by a user modifying a view of the results of a database query, the method comprising: generating the view of the results of the database query; providing a user interface for the user to modify the view of the results of the database query to define results of the updated database query, wherein modifying the view of the results of the database query comprises modifying an order of one or more fields shown in the view by dragging the one or more fields to indicate the order, adding a field from a table in the database to the view by dragging the field from the table to the view, filtering the view by indicating at least one field for filtering a plurality of records of the view, and further comprises adding one or more fields in a second table to the view; in response to modifying the view of the results of the database query and adding one or more fields in the second table to the view, generating a query definition based on a modification of the view of the results, wherein the query definition reflects a database join operation for adding the one or more fields in the second table; and running the generated query definition on a database to perform the updated database query.