JSON vs NoSQL

Deep JSON is way worse than complex table relations.

• Parsing a deep JSON structure is painful in the front end.

NoSQL DBs usually come with an un-nesting operation.

E.g. in MongoDB

db.collection.aggregate([
  {
    $project: {
      name: 1,
      city: "$address.city",
      zip: "$address.zip",
      phoneType: "$phones.type",
      phoneNumber: "$phones.number"
    }
  },
  {
    $unwind: "$phones" // This will flatten the array
  }
])