DEV Community

Cover image for Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

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

Alex Antra on August 13, 2020

I currently work for a great company called Xero doing all sorts of fun data things. When you're reading my articles I need you to understand tha...
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.