Migrate tries to drop + recreate column when changing type from TEXT -> CITEXT (Postgres)

[sdnts]

Reproduction

1. Start with this schema (Postgres):

model User {
  id String @id @default(cuid())
  email String
}

2. Create a migration using migrate dev. This is the migration that gets created:

-- CreateTable
CREATE TABLE "user" (
    "id" SERIAL NOT NULL,
    "email" TEXT NOT NULL,

    PRIMARY KEY ("id")
);

3. Then change the schema to:

model User {
  id String @id @default(cuid())
  email String @db.Citext
}

4. Create the CITEXT extension manually:

CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;

5. Run migrate dev again, this is the second migration that is created:

/*
  Warnings:

  - Changed the type of `email` on the `user` table. No cast exists, the column would be dropped and recreated, which cannot be done if there is data, since the column is required.

*/
-- AlterTable
ALTER TABLE "user" DROP COLUMN "email",
ADD COLUMN     "email" CITEXT NOT NULL;

Expectation

Only the column type is ALTERed.

[tomhoule]

Taking this in to confirm quickly if a cast is possible.