Can I run external SQL scripts as part of drizzle migrate?

[qiushiyan]

I am using drizzle + supabase and want to use pg_cron to schedule some periodic jobs, which I don't think can be directly added through the schema. The rest of the tables is managed inside drizzle without external migration tools. I am currently writing custom SQL scripts and applying them manually after drizzle-kit migrate when I need to reset db. Is there anyway I can include my script as part of drizzle's migration, so drizzle still handles 100% of the db structure?

[ahofmeister]

Just stumbled via Google on this: Do you want drizzle-kit generate --custom? It basically generates an empty SQL file, in which you can add your custom SQL and then migrate it is as usual with drizzle-kit migrate

I am in the same situation and will use drizzle-kit generate --custom, since I am planning on self hosting, manually applying the SQL script won't work properly