Is D1 a dialect? I thought they actually run SQLite.

I hit some issues where they worked in localhost but not in production. Fortunately, they're not dealbreakers. Unfortunately, my mind is very good at forgetting bad experiences (especially if they have a workaround), so I don't remember the issues.

I do know the transaction is handled "differently".