Yep, even raw-bog-standard PostgreSQL has fantastic nosql style storage with far more features than something like mongodb. Although I personally always question why someone thinks they need a nosql style storage, having a properly typed system is always far safer and often much faster.

N-to-M join tables.

Unsure what that is modeling but a transaction can do multi-updates atomically.

Join tables don’t care about depth. ^.^

All of which are just normal queries or (materialized) views, which are bliss. ^.^

This is all entirely not only supported by SQL but would be very well modeled as such, plus it helps to think how to model the data as it helps to get the code in better order as well. More ‘types’ is always better.

I’ve heard that argument many times and also seen it ripped apart many times. What you said at the end is precisely the most cited reason why it fails but that’s not even the biggest reason, which is the failure of typing and reliability around knowing the types.

What features are you looking for from a mongo driver? There has been some improvement on it since I wrote that.