Go package for parsing SQLite or SQL-92 queries.
The module builds with Go 1.11 and later. Regenerating sql.go with
make -B sql.go requires Go 1.17 or later for versioned go run support.
The Makefile pins the generator that reproduces the committed parser byte
for byte.
The backbone of this repo is extracted from vitessio/vitess.
Inside vitessio/vitess there is a very nicely written sql parser. However as it's not a self-contained application, I created this one. It applies the same LICENSE as vitessio/vitess.
import ( "github.com/CovenantSQL/sqlparser" )
Then use:
sql := "SELECT * FROM table WHERE a = 'abc'" stmt, err := sqlparser.Parse(sql) if err != nil { // Do something with the err } // Otherwise do something with stmt switch stmt := stmt.(type) { case *sqlparser.Select: _ = stmt case *sqlparser.Insert: }
Alternative to read many queries from a io.Reader:
r := strings.NewReader("INSERT INTO table1 VALUES (1, 'a'); INSERT INTO table2 VALUES (3, 4);") tokens := sqlparser.NewTokenizer(r) for { stmt, err := sqlparser.ParseNext(tokens) if err == io.EOF { break } // Do something with stmt or err. }