Hi, Calcite parser parses select statement to SqlSelect class which gives ability to set (selectList/ from/ where) clauses. While I was looking for examples I found this message (Parsing SQL) by Renato Marroquín Mogrovejo in February 2015 archive <http://mail-archives.apache.org/mod_mbox/calcite-dev/201502.mbox/browser>. Moreover, your reply was there are multiple ways to modify sql after parsing.
Actually, I want to edit sql queries by: 1- adding some conditions in where clause. 2- adding a table to from clause. Our queries have some little bit complication; that means nested, sub-queries and union. Further, we want to add the modifications in a certain parts. Are there other methods better than using SqlSelect class? Thank you in advance SSamra
