wren-engine icon indicating copy to clipboard operation
wren-engine copied to clipboard

Handle `EXTRACT(DAY_OF_WEEK)` in SQLGlot

Open grieve54706 opened this issue 1 year ago • 0 comments

Description

In Trino, The field of EXTRACT is DAY_OF_WEEK. But in BigQuery, the part of EXTRACT is DAYOFWEEK. We need to handle the SQL transform at SQLGlot by overriding.

https://trino.io/docs/current/functions/datetime.html#extract https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#extract

grieve54706 avatar Nov 01 '24 04:11 grieve54706