[BUG]: it's still showing that the column types are incompatible even though I have changed the type

[Boby900]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

^0.36.0

What version of drizzle-kit are you using?

^0.27.1

Other packages

No response

Describe the Bug

I have changed the type of the user_id column from integer to text,
I was referencing this column in two other columns as well so even though in my migrations files it's showing that it altered the type of all the tables("foreign key included") it's saying that types are incompatible.
I have some existing data in the tables which is of type integer but from now on I want to change the type of all tables from integer to text

[Boby900]