Metabase - SQL_PUSH_DOWN custom Expression Float32 not supported

[pauldheinrichs]

Describe the bug

When attempting to build a custom expression with CUBE_SQL_PUSH down enabled while building a question, Metabase generates a question expression as follows CAST(count(*) as float) resulting in an error

Execution error: Type Float32 is not supported in response transformation from Cube

---

Manually updating the SQL to use the type int works just fine too ex:

CAST(COUNT(*) AS int)

---

While this can be solved by creating a measure, feels like something SQL_PUSH_DOWN should support to some capacity?

This is on the latest version of cube