Check if the query parser could be replaced by the JOOQ or JSqlParser

[bchapuis]

https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/

https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-parser/

Set Settings.parseUnknownFunctions to IGNORE

[ebocher]

Hi @bchapuis ,
Let's share with you this excellent SQL parser : https://github.com/JSQLParser/JSqlParser
Cheers

[bchapuis]

@ebocher Thanks a lot for the pointer and the interesting discussion, this is definitely a solid candidate to replace my poorman's parser, especially if the Postgresql syntax is well supported.

[ebocher]

It will be a pleasure to share experience, feedback and go ahead with you and the Suisse team ;-)

[bchapuis]

@ebocher I just gave a try to the parser and one of my use cases involves a feature which will be released in 4.1. Basically, it is not yet possible to parse this kind of queries with JSQLParser.

"SELECT id, hstore(array['tag1', 'tag2'], array[tag1, tag2]), geom FROM table"

But so far, the experience with this library is pretty good and it may help at optimizing the queries further.

[ebocher]

Nice and it seems there is a release in the pipe JSQLParser/JSqlParser#1231

[bchapuis]

Yes, that's great, I just have to be patient.