Handling sqlite locally and d1 production db?

[safe ocean]

How do I handle these two environments?

[late light]

You chose to debug with a human. They'll tinker with your query soon. If you get curious meanwhile, hop into #ask-ai for a quick spin!

[tardy cobalt]

I assume you are able to run D1 as expected for your production by following this guide:
https://www.prisma.io/docs/guides/cloudflare-d1

However, for developing locally you would like to use Sqlite instead of D1, right?