Quote:
* I recommend changing the contextual menu prompt to something like “Copy buffer to Clipboard.” If not that, then don't allow partial selection in the window.
You can copy partial queries by pressing Ctrl+C
Quote:
What's the recommended procedure for re-executing a previous SQL query?
Paste the above selected text in the SQL window and execute them.
Quote:
Related, is there a way to copy/paste table and column names from the left pane into a query?
No.
There is a workaround though – click on the Table in the ObjectBrowser and its whole structure will be generated in the Objects tab. You can copy table/column names from there.
HTH