What is the recommended way to have a staging and a production environment?

For the record, I'm using Cloudflare D1. I know how to set up the

wrangler.json

wrangler.json

file such that based on the environment I use a different database (same binding, just different database IDs). How can I make it so the

drizzle.config.ts

drizzle.config.ts

file uses a different

.env

.env

file based on the environment being used?