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.

stackoverflow.com/questions/660609/sql-parser-library-for-java — atrain
– atrain, Commented Sep 20, 2011 at 15:55

Blindy · Accepted Answer · 2011-09-20 15:38:23Z

2

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

answered Sep 20, 2011 at 15:38

Blindy

68k10 gold badges96 silver badges141 bronze badges

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

Collectives™ on Stack Overflow

Parse SQL query in Java with UTF-8 support

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related