Support Format SQL Code

[eladcandroid]

• VSCode Version: 1.3
• OS Version: Fedora 24

Steps to Reproduce:

1. Paste a SQL code
2. Try to format the code
3. No change..
   

[alefragnani]

I was starting to create an extension for this 😄

I tested 3 different npm packages that does the job, but for complex statements, the results were mixed (not as good as I wanted). But I didn't play that much with each package to see how flexible it was to customize the formatting rules.

The ones I tested:

• format-sql
• sqlformatter
• vkbeautify

@weinand do you pretend use an in house approach or search for npm packages? Let'me know if you need any help/info about the results that I found.

[weinand]

@eladcandroid I'm just doing VS Code issue triage this week, so don't expect any additional insights or recommendations from me. I've added the 'help-wanted' tag to indicate that the VS Code team does not intend to work on this feature request.

Two tips:

• You might want to contact the authors of other SQL extensions.
• Consider to investigate how other VS Code language extensions provide formatting functionality.

[dmahendrakar]

I want to contribute this feature. I have been able to investigate how javascript VS Code language extension provide formatting functionality. Can anyone please tell me why "onLanguage:javascript" activationEvent is handled in TypeScript package.json?

[aaronsteers]

I'm interested in contributing to this cause. Does anyone have a project started?