How to override Prisma DB kind (i.e. SQLite versus PostgreSQL)?

Question

I want to use SQLite during debugging a Next.js app with Prisma DB and PostgreSQL in production (yes, I am aware that these two DBs have different features).

But, AFAIK, provider is a constant:

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

(that is, provider = env("DATABASE_KIND") does not work).

How can I do this? The only idea that I have is to preprocess the .prisma file.

I am aware of this question but they seem to ask (and answer) only how to change the data source, not the kind of the DB.