The queries derived from DuckDB are not compatible.
For example: WHERE d_date BETWEEN '2002-02-01' AND cast('2002-04-02' AS date) throws an error in Presto because one predicate has no cast.
https://github.com/duckdb/duckdb/blob/main/extension/tpcds/dsdgen/queries/16.sql
The queries derived from DuckDB are not compatible.
For example:
WHERE d_date BETWEEN '2002-02-01' AND cast('2002-04-02' AS date)throws an error in Presto because one predicate has no cast.https://github.com/duckdb/duckdb/blob/main/extension/tpcds/dsdgen/queries/16.sql