I tend to think of the biggest difference between SQL and NoSQL is the latter will generally trade normalization features in favor of better scaling characteristics. Usually adopting embedded child data and doesn't.

Often the advantage is easier horizontal scaling through replica rings or sharding.