Error: This Durable Object is not backed by SQLite storage, so the SQL API is not available.

I am using the SQL API for Durable Objects but this is coming up only on remote.
I have the following in my wrangler.jsonc under my environment
"migrations": [
{
"tag": "v1",
"new_sqlite_classes": [
"MyDurableObject"
]
}
],

This works in dev mode. Does anyone know what is wrong?