scripting features

[adamfoneil]

To make the schema browser feature really useful, and achieve more parity with SSMS, there should be a number of SQL scripting features available from the schema browser context menu. I'd started on this with a "select columns" command that toggles checkboxes, but currently it doesn't do anything. Here's what I'm looking for in such a feature, but I don't have any particular UI in mind.

• create INSERT statement for required, all, or select columns in a table
• create SELECT statement with all or select columns, optionally prefixed with a table alias
• create JOIN statement when clicked on FK node
• all script options may toggle use of square brackets around names
• probably want some kind of wrapping so that a long list of columns doesn't go on one very long line

In my original conception of scripting features, I imagined that when you click "select columns", a panel in the lower portion of control would become visible, and show the result of your selections with various copy/insert controls. This is how you'd be able to have a deeper interaction with your selections before inserting them as SQL -- for example setting the table alias, the square bracket option, and so on