I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice.
Right now the extension is using regex, which isn’t the best for parsing SQL but it works for the few test cases I’ve added.
I’m hoping that the community can help evolve the project into something really cool; so, I’m asking for your help in making that happen.
The public project can be found here: https://github.com/DanielJanik/tsqlchecker_adsextension
Here’s a little sample of the extension at work:
Finally, I’d like to thank Drew (https://github.com/dzquared) for creating the step-by-step extension development walk-through that I always wished I could create. Thanks so much Drew for your great work to the community and the guidance you gave me over twitter pms.
I strongly recommend you check out his walk-through here: https://github.com/dzsquared/AzureDataStudio_ExtensionDevelopment/blob/master/0-Prereqs.md