Enhancement Request: Result grid and copy as SQL

[ScottMattes]

PLSD 10

Today I need to hand jam some test data, so I queried the table, selected the first result row and exported as SQL. The resulting INSERT statement is a great starting point.

I would like to be able to have inline comments put on each value line - the comment would be the column name. This would be awesome for most of our tables because the column lists are long.

Here is an example of what I am after:

INSERT INTO myTable
FIELDS
(Col_1,
 Col_2)
VALUES
('xyz',  -- Col_1
 123     -- Col 2);

I know that it is optional, but I'd also like generated INSERTs to have FIELDS in them.

Thank you.

 

[Marco Kalter]

In version 11 the corresponding column will be highlighted.

 

[ScottMattes]

Marco,
I like that! But, I think that is only a partial solution. If the code is formatted one column per line, and there are many lines, the corresponding column name could easily be off the top of the screen.

 

[Maxmix]

Marco, could you exclude ROWID columns from generated INSERTs?