Hello, I have been looking for a library which will allow me to use an object tree to generate a SQL. Calcite came up in my search but after taking a look at the codebase my conclusion is that Calcite provides the ability to parse SQL statements into an object tree represented as SQLNode (and derived classes) instances which subsequently can be used to perform optimizations by generating relational algebra for the logical query.
Calcite however does not provide classes which can be used to assemble a tree and generate SQL statements. From the contracts at least SQLNode takes in a Parser position and there are no other contracts which indicate such an option. Can someone confirm if this is inaccurate? If not Calcite, are there other open source libraries out there which allow this? Thanks in advance. -Sandeep
