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 directory where I keep my frontend and is what is built when I run
npm run build
to the /dist directory.
And I have my
/functions
directory which is of course where I am storing my backend API.
I am wondering if I should use a /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?
Was this page helpful?