wren-engine
wren-engine copied to clipboard
Handle `EXTRACT(DAY_OF_WEEK)` in SQLGlot
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