Only one person in this comment thread mentioned CAP theorem, which is the (highly informal*) rationale for NoSql's existence and also its deliberate aversion to join dependencies (which more or less violate the core principles of eventual consistency modeled distributed data stores.)

Useful links for erudition:

https://arxiv.org/pdf/1302.0309.pdf

https://codahale.com/you-cant-sacrifice-partition-tolerance/

https://martin.kleppmann.com/2015/05/11/please-stop-calling-...

https://www.somethingsimilar.com/2013/01/14/notes-on-distrib...

https://www.microsoft.com/en-us/research/publication/replica...