Proposal: Add 'Copy selected as IN (....)' to grid context menu

[gpshonik]

A common scenario when troubleshooting, especially when comparing records between local and prod databases, is to be able to quickly select a range of PKs or other values and copy them as an IN (...) clause, properly quoted depending on the type.

This would copy IN (1,2,3,4) to the clipboard.

Copy Select as IN (...) would be in this context menu, but it probably only makes sense when values from a single column are selected.

I think this would a useful feature!

Edit: If this feature sounds like a good addition I would be happy to take the first pass at the implementation and submit PR.

[alex-bochkov]

Yes, I think this is a great idea.
Done in #51
Please take a look and let me know if you would like to change anything.

[gpshonik]

This looks geat! Thanks for the quick turnaround!

[gpshonik]

I did have a thought - what would you think about adding newlines? It might be more readable for very long statements especially with the Copy All As ... option.

(1, 2, 6, 9, 13, 14, 15, 16, 17, 20, 22, 24, 27, 29, 31, ...)

vs

(
 1,
 2,
 6,
 9,
 13,
 14,
 15,
 16,
 17,
 20,
 22,
 24,
 27,
 29,
 31,
 ...)

[alex-bochkov]

How about combining both options?
By default, insert a new line after each value. If the command is executed while holding the SHIFT key, generate a more compact version with a "reasonable" row length.
For example:

(1, 2, 3, 4, 5, 6, <up to X characters>
7, 8, 9, 10, 11, 12 <up to X characters>
13, 14)

[alex-bochkov]

This should do it - #56