It's actually sitting on top of Cloudflare's new SQLite storage in Durable Objects. You can learn more here:

https://blog.cloudflare.com/sqlite-in-durable-objects/

There's actually a section called: What about D1?