Run a custom migration via raw query on a Vapor Fluent database.

migrations.swift

struct CustomRawMigration: AsyncMigration {
    func prepare(on database: Database) async throws {
        try await (database as! SQLDatabase)
            .raw("ALTER TABLE `table_name` MODIFY `field_name` ENUM('case1', 'case2', 'case3') DEFAULT 'case1'")
            .run()
    }

    func revert(on database: Database) async throws {
        try await (database as! SQLDatabase)
            .raw("ALTER TABLE `table_name` MODIFY `field_name` ENUM('case1', 'case2') DEFAULT 'case1'")
            .run()
    }
}