/ANTSQLParser

SQL parser program with ANTLR4 and great contributors.

Primary LanguageANTLRMIT LicenseMIT

ANTSQLParser

TSQL parser program with ANTLR4 and great contributors.

Github issues Github forks Github stars Github top language Github license

Tags

tsql sql parser

Demo

sqlparser -o xml -s "select * from tab1 join tab2 on tab1.a=tab2.b"
Demo

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

Advantages

this program support

  • dml
    • merge
    • delte
    • insert
    • select
    • update
  • ddl
    • alter
    • create
    • drop
    • etc
  • backup statement
  • flow control statement
    • begen
    • break
    • if
    • goto
    • return
    • throw
    • try
    • etc

Installation

git clone https://github.com/GCer-Hidenori/ANTSQLParser.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

Contributors