I expect most workloads are more OLTP/transactional than OLAP/analytical.
(I use it personally, but it's not the same thing as what we're building with D1)
Basically, we already have a product for doing DuckDB-like things, and the D1 architecture isn't great for high volume OLAP workloads.
Disclaimer: I'm an engineer at Cloudflare, but not on a developer platform team. I'm not speaking for our developer platform strategy or anything, I'm just commenting on how it looks from where I sit.