SQL API: Failed to plan inner queries with IN

[kderbalah]

Failed SQL

SELECT country, MEASURE(checkout_rate) AS checkout_rate
FROM customers
WHERE country IN (
    SELECT country
    FROM customers
    GROUP BY country
    ORDER BY SUM(num_customers) DESC
    LIMIT 5
)
AND year_utc = EXTRACT(YEAR FROM CURRENT_DATE) + 0
GROUP BY country, week_of_year_utc
ORDER BY week_of_year_utc, checkout_rate DESC

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