DEV Community

Discussion on: Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Collapse
 
waylonwalker profile image
Waylon Walker

This is soo cool. SQL tools are so sparse. I have found one auto formater that kind of works for me, but no linter.

The tool that I would really like to see for SQL is a transpiler. I would like to work from a more common flavor of SQL and have it transpiled into the various dialects.

Somehow it seems that SAS does this. I have shared code between myself and a SAS user. I will run into errors with dialect and somehow they get by just fine. I have no idea what was is doing under the hood, but it seems amazing.