Parse SQL query in Java with UTF-8 support

Question

What (tool, library, way) can you recommend for parsing SQL query in Java?
I need to change column names in output, so for example:
I want to change query from:

SELECT a AS one, b AS two FROM xyz ORDER BY 1

to

SELECT a AS one_1, b AS two_2 FROM xyz ORDER BY 1

There might be many queries in one file to parse.

I tried using JSqlParser, but it doesn't support UTF-8 in SQL statements.

http://stackoverflow.com/questions/660609/sql-parser-library-for-java — atrain, Sep 20 '11 at 15:55
Try out.. [ZQL parser](http://zql.sourceforge.net/). its free to use. — chetan, Jun 20 '14 at 08:03

score 2 · Accepted Answer · answered Sep 20 '11 at 15:38

2

JSqlParser comes to mind. Never used it, but seems to fit the bill pretty well.

answered Sep 20 '11 at 15:38

Blindy

65,249
10
91
131

Parse SQL query in Java with UTF-8 support

1 Answers1