Issue parsing postgres timestamptz as expression

[tpoll]

Postgres has syntax that allows you to write a query such as:

SELECT * from table where x >= timestamptz '2021-07-05 00:00:00+00'

This fails to parse with an exception

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\'2021-07-05 00:00:00+00\'" <S_CHAR_LITERAL>
    at line 1, column 44.

Interestingly SELECT * from table where x >= timestamptz('2021-07-05 00:00:00+00') (note the parens) does parse.

I also tested SELECT * from table where x >= timestamp '2021-07-05 00:00:00+00' which does properly parse.

I'm not too familiar with the parsing grammar, but it seems like maybe timestamptz just needs to be treated similarly to timestamp?

Happy to open up a PR if someone can point me in the right direction to get started.

[manticore-projects]

Greetings @tpoll. Thank you for considering to solve it by yourself.

You would need to:

1. Edit the JavaCC Grammar and add your new Token
2. Add a Test Case to Parse and Deparse your statement
3. Run all Tests to ensure, that everything is still working
   4( Submit your PR

(Usually there is more to do, but in this case just adding a token could do.)

[manticore-projects]

Interestingly SELECT * from table where x >= timestamptz('2021-07-05 00:00:00+00') (note the parens) does parse.

Simply because Anything(...) is parsed as a Function() (without understanding the particular means or purpose of Anything).
But since timestamptz '2021-07-05 00:00:00+00' does not match a Function() and not any allowed DATE_TIME_LITERAL you will need to declare it in the Grammar.

[tpoll]

Thanks for the pointers @manticore-projects. I opened up a PR which I believe should safely add support.