Skip to content

SQL parser program with ANTLR4 and great contributors.

License

Notifications You must be signed in to change notification settings

sqlartist/ANTSQLParser

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

SQL parser program with ANTLR4 and great contributors.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Jupyter Notebook 59.4%
  • ANTLR 37.4%
  • C# 3.2%