Hi Calcite community, I'd like to use Apache Calcite to help me 1) parse and validate an arbitrary SELECT statement and 2) replace the FROM clause with another table or a subquery.
At the moment, I can do 1) ok and I have a validated AST. What's the appropriate way to do 2)? I checked various examples online, but since this is not a common use case, I couldn't find anything helpful. Any suggestions are highly appreciated. Thanks. Thomas
