TSQL parser with Microsoft SQL Server Transact-SQL ScriptDom.
tsql
sql parser
sqlparser -o xml -s "select * from tab1 join tab2 on tab1.a=tab2.b"
sqlparser -o json -s "select * from tab1"
High accuracy of parsing because this program is made with MicrosoftR SQL ServerR Transact-SQL ScriptDom.
https://www.microsoft.com/en-us/download/details.aspx?id=56833
git clone https://github.com/GCer-Hidenori/TSQLScriptDomParser.git
- XML
sqlparser -o xml -s "select * from tab1 join tab2 on tab1.a=tab2.b"
- json
sqlparser -o json -s "select * from tab1 join tab2 on tab1.a=tab2.b"
- string
sqlparser -o json -s "select * from tab1 join tab2 on tab1.a=tab2.b"
- file
sqlparser -o json -f select01.sql -e utf-8