Quality Of Life enhancements

[pawelsalawa]

• Database list - Ctrl+drag table/view onto the SQL Editor -> generate SELECT.
• Database list - Ctrl+drag selected columns onto the SQL Editor -> generate SELECT with these columns.
• Database list - Ctrl+Shift+drag table onto the SQL Editor -> generate UPDATE.
• Database list - Ctrl+Shift+drag selected columns onto the SQL Editor -> generate UPDATE with these columns.
• Database list - Drag selected columns (without meta keys) onto the SQL Editor -> paste column names, comma-separated.
• Grid View - F4 to edit contents in a MultiEditor dialog - this will replace Alt+Enter
• SQL Editor - F3 on an object to open that object (Table Window, View Window, Index Dialog, Trigger Dialog)
• Expanding asterisk operator in SELECT to actual columns using a shortcut, or with Code Assistant when triggered on the asterisk.
• Configuration Dialog should remember tab on which it was closed and next time reopen on that tab.
• Add suitable items from this list to TOD ("Tip of the day" message in status window #3283)

[JrgMyr]

Very helpful, indeed. Thank you.

Is there a way to expand the asterisk in queries into the series of field names? Example: one wants to write a query with several fields. Writing "select * from xyz" then expanding the asterisk into the actual columns, then erasing the unwanted ones could also reduce typing.

[pawelsalawa]

Awsome! Adding it to the list.

[JrgMyr]

It would probably suffice if one could drag and drop column names (ideally multiple at one time) from the database pane on the left into queries. Right now table names can be moved this way but not column names.

[pawelsalawa]

Another one good! Adding.