Attached is the patch to allow tree nodes to be dragged and dropped in query editor wherever you take the drop cursor. The drop text will be fully qualified and double quoted if required.
For functions/procedures it will drop the the label stripping away the parameter names, with empty pair of round brackets. It will also set the focus cursor inside the brackets if there were params otherwiser to the end of text.
For adding a node type, you need to register it in browser.js along with a callback function which will return drop text along with cursor positioning and selection. Currently, I have registered for "table partition type sequence package view mview foreign_table edbvar schema column edbfunc function edbproc procedure".
Please note, the drag design customisation is not supported in IE.
I think for functions/procedures, we should include placeholders for the parameters, so the user has a hint about what they need to fill in to complete the call.
I can fill in the parameter names same as tree node, with cursor selection on all the params ?
Can you select the first one, and put the cursor in front of it?
Yes. Will do that. So that, just after drop if the user types anything it will replace the first param name.