You need to choose the technology (relational DB vs document DB) according to your (detailed) use case. If your use case deals with relational data why would you transform the relational data into a document on write only to transform it back from document to relational on read? The issues you described are typical examples and won't go away. Stick with PostgreSQL (or any managed SQL DB)