Ability to copy a value in the grid along with the column it belongs and formatted for WHERE clause
For example, let's assume this is the output from a query:
id name role
1 Torn ADMIN
2 John CLERK
3 Adam SUPER
I would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.
In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
name = 'Adam' and role = 'SUPER'
I'd add another one that is very useful, in your example, if you select the three ID values then it should copy
(1, 2, 3)
id IN (1, 2, 3)
or if you copy the first and second role then it should copy
role IN ('ADMIN', 'CLERK')
Toad for MySQL has this feature