CAST(.. AS INTEGER) is not supported in MySQL

[peasee]

Describe the bug

CAST(.. AS INTEGER) is not supported in MySQL, as INTEGER is not a valid cast type.

To Reproduce

Create an execution plan using the MySQL Dialect that induces or includes a cast to an integer. Observe the generated SQL failing to run on a MySQL connection source, due to the CAST(.. AS INTEGER).

Expected behavior

The execution plan should generate SQL with types compatible for MySQL, when using the MySQL Dialect. In this case, CAST(.. AS SIGNED).

Additional context

No response