Match between enum and text in relations with Postgres

[stefanosandes]

Hello everyone!

Based on some tips coming from this issue, I'm trying to implement a polymorphic association like with Drizzle.

My code is something like this:

export const documentableTypeEnum = pgEnum("documentable_type_enum", ["user", "product"]);

export const notifications = pgTable("notifications", {
		id: nanoid("id"),
		notifiableId: text("notifiable_id").notNull(),
	    notifiableType: documentableTypeEnum("notifiable_type").notNull().,
        // ...
});

export const users = pgTable("users", {
	id: nanoid("id"),
	notifiableType: text("notifiable_type").default('user')
	// ...
});

export const notificationsRelations = relations(notifications, ({ one }) => ({
	user: one(user, {
		fields: [notifications.notifiableId, notifications.notifiableType],
		references: [user.id, user.notifiableType],
	})
}));

So, because notifiableType is an enum on the notifications table and a text on the users table, I'm getting this error:

error: operator does not exist: notifiable_type_enum = text

Is there a way to cast the enum when comparing? I tried to do this fields: [notifications.notifiableId, sql`${notifications.notifiableType}::text`], as AI docs suggested, but it doesn't work.