D1 is fine when it fits the use case, but most of the time I just want Postgres that I will use for absolutely everything. It has happened often enough that I have tried to make systems work with other storage systems, and eventually just give up and revert to Postgres. Every time I just start with Postgres I don't have issues until it turns out my laziness has caused a performance problem, and those I can fix.