Escape Date Literal {d 'YYYY-MM-DD'} Causes SQL Parser Error

[willshen99]

I'm using duckdb ODBC driver with SAS. SAS automatically generated ODBC escape date literal format {d 'YYYY-MM-DD'}, and DuckDB throws a parser error:

ERROR: CLI prepare error: ODBC_DuckDB->duckdb->PrepareStmt Parser Error: syntax error at or near "'2024-01-01'"  LINE 1: ...", "encounterid"  FROM
DIAGNOSIS  WHERE  ( "admit_date" >= {d '2024-01-01' } )                                                                      ^
SQL statement: SELECT  "admit_date", "encounterid" FROM DIAGNOSIS  WHERE  ( "admit_date" >= {d
'2024-01-01' } ).

Does DuckDB recognize date literal {d 'YYYY-MM-DD'}, or is there any option in the driver to translate it to DATE 'YYYY-MM-DD'?

[staticlibs]

Hi, thanks for the report! Currently ODBC escape sequences are not supported.

[willshen99]

Thanks @staticlibs for the quick response! Are there any plans to support ODBC escape sequences in the future?

[dcorbit]

The grammar for ODBC Date, Time, and Timestamp Literals can be found here:
https://learn.microsoft.com/en-us/sql/odbc/reference/appendixes/date-time-and-timestamp-escape-sequences?view=sql-server-ver17
I attached a file that uses grammar for dates here as a test case:
duckdbsamp.sql
Standard ODBC escapes work with with all common ODBC drivers, including: Adabas, DB/2, Disam, Informix, Oracle, PostgreSQL, Sql Server, and Sybase