Parse SQL query before it goes to MySQL

Question

In my Go app I want to be able to analyze a SQL query before to execute it. I want to get: type (update, insert, delete etc). This is easy, but next steps not. table to be affected, columns to be updated (on insert/update) most important - condition, list of columns and values.

Is there any go library for this?

Something to pass a sql query and get back some structure with info about this query

Jagan · Accepted Answer · 2018-07-20 05:10:22Z

2

Yes, you have sqlparser for golang.

Note that the sqlparser is been pulled out from the database clustering system vitess

You can use the sql parser like,

reader := strings.NewReader("INSERT INTO table1 VALUES (1, 'a');")

tokens := sqlparser.NewTokenizer(reader)
for {
    stmt, err := sqlparser.ParseNext(tokens)
    if err == io.EOF {
        break
    }
    // Do your logics with the statements.
}

answered Jul 20, 2018 at 5:10

Jagan

5,2567 gold badges41 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

maksimov Over a year ago

I would suggest importing the parser from vitess.io/vitess/go/vt/sqlparser directly as the above mentioned one has not been maintained for over 4 years now.

Collectives™ on Stack Overflow

Parse SQL query before it goes to MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related