What do you mean with "it introduces a lot of other problems"?

Fair point, although we didn't choose MongoDB just because of schema handling. We've been using MongoDB in production since 2013, so it was a natural choice since we already know a lot more about it than any other database.

For the problems you're mentioning, what we've seen is that many people use it incorrectly, and we're building the framework in a way that prevents that in the app layer. But still curious about your experience - what are the biggest problems you've had in production MongoDB?

Totally agree, schema issues are easily solved with solutions like drizzle or prisma.

I would never go full mongo considering how easy is now a days to have TypeScript first postgres.