It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
SQL testing and analysis tools are (so far as I'm aware) limited to linters like sqlint and unit tests in the form of pgTAP. I don't know of anything that does what you're envisioning, but it involves static analysis similar to a linter -- just with a different final objective.
I would definitely target the most general platform possible. A standalone binary which can be glued with little effort to any plugin-supporting editor is the best way to go; VSCode is big, but it's not everything. Powershell is likely not a great idea unless you only care about SQL Server since other SQL-writing audiences trend Linuxy.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
SQL testing and analysis tools are (so far as I'm aware) limited to linters like sqlint and unit tests in the form of pgTAP. I don't know of anything that does what you're envisioning, but it involves static analysis similar to a linter -- just with a different final objective.
I would definitely target the most general platform possible. A standalone binary which can be glued with little effort to any plugin-supporting editor is the best way to go; VSCode is big, but it's not everything. Powershell is likely not a great idea unless you only care about SQL Server since other SQL-writing audiences trend Linuxy.