Where do I store SQL migrations in my Pages app's repo?
I am interested to start a new project using Pages but I want to use D1 in this Pages app. I've gone ahead and setup my basic Pages repo where I have a
/site
/site
directory where I keep my frontend and is what is built when I run
npm run build
npm run build
to the
/dist
/dist
directory. And I have my
/functions
/functions
directory which is of course where I am storing my backend API. I am wondering if I should use a
/sql
/sql
directory to house the SQL and migrations? Or should this be kept in a different repo?
Main question - how should I be structuring my Pages repo and use/include D1 migrations?