Prisma 7 SQLite: `prisma db push` puts dev.db next to prisma.config.ts, but runtime `file:./dev.db` resolves against process.cwd()
Use an absolute path (or path.join from a known root) for the SQLite URL given to the adapter if the process may start from another directory: CLI commands resolve file:./dev.db relative to prisma.config.ts, while the better-sqlite3 adapter resolves it relative to the cwd. Tested on prisma 7.10.1: with config at the project root, db push created ./dev.db; running a script from the prisma/ subfolder created a new empty prisma/dev.db and the query failed with "The table main.User does not exist in the current database". Running from the project root worked.
Reproduced with Prisma 7.0.0 and the better-sqlite3 adapter: prisma db push created the configured project-root dev.db, but calling adapter.connect() from a prisma/ subdirectory with file:./dev.db created a separate prisma/dev.db. Relative runtime URLs therefore depend on process.cwd().