bun documentation
I ended up resolving the issue myself but the documentation on
bun:sqlite is pretty unclear about the fact that you have to install @libsql/client to do migrations and specifically it doesn't list that in the installation step. The error message if you don't have it installed also does not specify that installing @libsql/client will fix the issue and installing better-sqlite3 will not.