SQL API: `EXTRACT` date fileds is not possible

**Failed SQL**
```sql
SELECT category, MEASURE(num_customers) AS total_customers
FROM customers
WHERE week_utc IN (
(EXTRACT(YEAR FROM CURRENT_DATE) + 0) * 100 + EXTRACT(WEEK FROM CURRENT_DATE) + 0,
(EXTRACT(YEAR FROM CURRENT_DATE) + 0) * 100 + EXTRACT(WEEK FROM CURRENT_DATE) - 1,
(EXTRACT(YEAR FROM CURRENT_DATE) - 1) * 100 + EXTRACT(WEEK FROM CURRENT_DATE) + 0
)
GROUP BY category
```

**Error**
SQL Error [XX000]: ERROR: Error during rewrite: Can't detect Cube query and it may be not supported yet.

**Logical Plan**
Error during planning

**Version:**
v0.35.55

**Additional context**
I see same error when enabling SQL pushdown