Currently on the SQL tab there is a single query text box and a set
of tabs for past results.
Often I find that I am not interested in past results if I am just
running a set of simple queries - it would be OK to just over-write
previous results. The times that I am interested in previous
results, I'm also interested in the SQL text used to create them,
which I can't view concurrently with the results.
So, I propose that tabbed results be removed. Instead, provide
tabbed queries in which each tab would contain the SQL text and
the (single) result. Visually, this would be equivalent to moving
the results tab to a spot below the "Options / SQL" tab and above
the combo box.
Additionally, I propose that buttons be added next to the SQL text
box for "Copy to new Query" and "Create new empty Query".
To the user, it would work as such:
Switch to the SQL tab and there is an empty query tab already
created. Type in an SQL statement and run it, the results display
below. Type in another statement and run it, the results overwrite
the previous values. Click 'Copy to New Query' button and the
current SQL text is copied to another tab.
As an additional bonus, this would allow the user to flip back thru
previous queries and copy/paste chunks out of them to help
construct a new queries - something that is quite difficult now.