Use Calcite in own codegen tool (needs to parse DB2 SQL-dialect for AS/400) ?

[Larry LeFever]

I'm developing a codegen tool to facilitate development of custom reports
where I work.

One step in the codegen process reads the top-level column-aliases of a
usually very complex report-backing query (lots of subqueries, some use of
listagg, etc.) and uses those aliases to generate a db-row POJO.

I've used ANTLR's SQLLite generated parser for that, but it encounters DB2
for AS/400 specific SQL it can't handle.

I believe I've seen in some of the documentation a component of Calcite for
the DB2 SQL-dialect.

So, I'm wondering if I could incorporate Calcite into my codegen tool to
use its SQL-parsing functionality in the db-row POJO generating part of my
codegen tool.

Any advice would be much appreciated.

Larry LeFever