How can we improve SQL Prompt?

Autogen insert and commas at the beginning of the statement

I find having the commas at the beginning of the line extremely useful - and was glad that Sql Prompt allows us to set the default as such for insert statements. I have to say the format is quite difficult to read, and find that I have to rewrite it each time. Can you please spend a few minutes to clean it up? I see there are a couple outstanding requests that have been ignored for 2 years now - no input from redgate at all. I'm sure there are others who would agree with this - (just check out the votes). I can't imagine it being over-the-top difficult to pull off.

here is a sample of the output:

insert into dbo.TABLE
(F1
,F2
,F3
,F4
,F5
,F6
)
values (''
, -- F1 - varchar(10)
''
, -- F2 - varchar(255)
''
, -- F3 - varchar(100)
''
, -- F4 - varchar(255)
''
, -- F5 - varchar(255)
''
-- F6 - varchar(100)
)

Desired output:
insert into dbo.TABLE
(F1
,F2
,F3
,F4
,F5
,F6
)
values ('' -- F1 - varchar(10)
,'' -- F2 - varchar(255)
,'' -- F3 - varchar(100)
,'' -- F4 - varchar(255)
,'' -- F5 - varchar(255)
,'' -- F6 - varchar(100)
)

If this is not possible, or you do no have plans to ever touch this, can you please at least let the community know?

Thank you,
John

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    John HenneseyJohn Hennesey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base