Local Testing for D1?

before, to test locally with drizzle and d1:

"gen-local-db": "npx drizzle-kit generate:sqlite",
"init-local-db": "npx wrangler d1 execute clients --local --file=$(ls ./drizzle/*.sql| head -1)"

i used to do this, i am aware :sqlite is deprecated since we have a config file.
but initializing a local db no longer works:
✘ [ERROR] near ")": syntax error at offset 57: SQLITE_ERROR

I looked into the push command but it looks like it directly applies changes to the production database? What is the correct way to create a local database now.
Was this page helpful?