Sooo simple java SQL parser?

Question

Java

Interested in not a complete analysis, but a selective one. Those. you need to understand that this is, for example, a table creation operator and get the table name from it, everything else is of no interest, even if it is a deliberately incorrect expression like: “CREATE TABLE test_table;”, we get the value of “test_table” and stop. Or, for example, get the name of both tables in the forenkey creation statement.
It would also be great if these descriptions were stored in some kind of textual form, i.e. so that you can add a new object for parsing or change an existing one and still not rebuild anything.

Answer 1

Well, write regular expressions and get them with the help of them.
Well, regular expressions can be stored in a file without any problems.

Answer 2

There is a discussion on the stack about a similar question.
The following options are offered JSqlParser , ZQL and another paid option . They also recommended using ANTLR - it seems that the StringTemplate functionality is suitable for your case