OHDSI Home | Forums | Wiki | Github

No-dependency SQL parser/transpiler (19 SQL dialets)

This tool came up from Colorado’s DBMS Software Engineering team: https://github.com/tobymao/sqlglot
It is Python based, which makes it an unlikely candidate to replace the current R-based SQLRender. But I post it here in case either it provides any useful approaches or if there is the possibility of embedding it as a callable library within R (I really do not know what I’m talking about with this second suggestion).

Thanks! This looks really good. Too bad I can’t think of an easy way to use it in R.