Run only the part of the query you select

The query console now runs whatever is selected in the editor. Highlight one statement of a longer script and the button changes from "Execute Query" to "Execute Selection". Only the selected text is sent to the database, and the rest of the script stays in the editor for the next run. With nothing selected, the whole editor runs as before. Ctrl+Enter (Cmd+Enter on a Mac) now executes from the editor and follows the same rule. It is ignored while a query is still running, so a second press can't start an overlapping run.

Everything that works on the results works on the query that produced them. Sorting by a column header, adding a filter from a cell or column, paging, Save Query and Create API all use the statement that ran, not the whole script. When a sort or filter rewrites that statement, it is changed in place, and the other statements in the editor stay as they were.

Selecting part of a query can also make pagination available where it wasn't. A script of several statements can't be paginated, but a single SELECT selected from it can. Highlighting text just to copy it leaves your pagination setting unchanged.