When i query presto when there is a column with a reserved keyword like

timestamp

even though the spec for presto suggests that it can be escaped with double quotes, i cannot seem to submit a query that includes

"timestamp"

It might be specific to the clients I am using; i have tried the presto-cli freshly downloaded and a python client and both result in a PQLParsingError. What to do in this situation? (this is testing the presto-pinot connector but maybe not a Pinot question for this channel)

right, the generated pinot query also need to be escaped, but that is not set in presto pinot connector

thanks for the context @User 🙏