I saw a flash for something called SQL Fluff today: https://docs.sqlfluff.com/en/stable/. It was described as an open-source SQL Linter. There is also a VS Code extension: https://marketplace.visualstudio.com/items?itemName=dorzey.vscode-sqlfluff.
I only saw this today, and I have not had the time to try it myself.