SQL API: Can't plan queries with CTEs

**Failed SQL**
```sql
with countries as (
select country, MEASURE(num_customers) as num_customers
from customers
where month_utc = '202311'
group by country
order by num_customers desc
limit 5
)
select week_utc, MEASURE(checkout_rate) as checkout_rate
from customers
where country in (select country from countries)
group by week_utc
```

**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