TSQLScriptDomParser
TSQL parser with Microsoft SQL Server Transact-SQL ScriptDom.
Install / Use
/learn @GCer-Hidenori/TSQLScriptDomParserREADME
TSQLScriptDomParser
<!-- # Short Description -->TSQL parser with Microsoft SQL Server Transact-SQL ScriptDom.
<!-- # Badges -->Tags
tsql sql parser
Demo
sqlparser -o xml -s "select * from tab1 join tab2 on tab1.a=tab2.b"

sqlparser -o json -s "select * from tab1"

Advantages
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
Installation
git clone https://github.com/GCer-Hidenori/TSQLScriptDomParser.git
Minimal Example
output format
- 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"
input format
- 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
