Custom migration files? Triggers in SQLite

I want to do some triggers for sanity checks in my SQLite database and I know how to write the schema. Is there an escape hatch somewhere, that allows me to write my own up/down migrations?

Am I maybe overthinking this, and should just add a .sql file into the migration folder?
Was this page helpful?