Metabase week time dimension error

When we use week as granularity in Metabase, Metabase create query

```
SELECT (CAST(DATE_TRUNC('week', ("public"."analytics_analysis_view"."date" + INTERVAL '1 day')) AS timestamp) + INTERVAL '-1 day') AS "date", SUM("public"."analytics_analysis_view"."sessions_start_count") AS "sum"
FROM "public"."analytics_analysis_view"
GROUP BY (CAST(DATE_TRUNC('week', ("public"."analytics_analysis_view"."date" + INTERVAL '1 day')) AS timestamp) + INTERVAL '-1 day')
ORDER BY (CAST(DATE_TRUNC('week', ("public"."analytics_analysis_view"."date" + INTERVAL '1 day')) AS timestamp) + INTERVAL '-1 day') ASC
```

and then cube throw an error

```Error during rewrite: Can't detect Cube query and it may be not supported yet. Please check logs for additional information.```