how do I add custom constraint?

Ex: alter table shift_break add exclude using gist (shift_id with =, tstzrange("start", "end") with &&);

2 Replies

Did you find how to do this?

The best way right now is to generate an empty migration with Drizzle kit:

drizzle-kit generate --custom

drizzle-kit generate --custom

https://orm.drizzle.team/kit-docs/commands#generate-migrations Then, you write the SQL for that and next time you migrate it will apply like a normal migration

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.