Support JDBC date, time and timestamp escape sequences

[Chrriis]

JDBC drivers support the JDBC Date, Time, and Timestamp escape sequences.

Thus, the following is supposed to work using JDBC drivers (sometimes with addition of "FROM DUAL"):
SELECT {d '2016-06-29'}, {ts '2016-06-29 11:07:35.123'}

Unfortunately, it is not supported by this driver. This causes compatibility issue where standard JDBC SQL fails.

[gotson]

This causes compatibility issue where standard JDBC SQL fails.

Can you expand on that? Is that when using a framework?

[Chrriis]

Can you expand on that? Is that when using a framework?

Well, it is standard JDBC, so any tool relying on that could fail. Also, when one has to send date or timestamp in a query, this is a syntax that is compatible whatever the database is.

In my specific case, we use a proprietary framework that is using this syntax internally.

[gotson]

That would be quite difficult to implement, it would require a SQL parser in order to find and replace the escape sequences.