You get JSONB with postgres, which, to me, is a significant difference. This means you can indexing by key/value, access keys directly, without parsing the whole json string, etc.
For my use case, JSONB support completely killed most NoSQL solutions.
Sorry, I should have said JSONB. Do you still consider a table with a single JSONB column SQL or NoSQL? Sure, it may be contained within a RDBMS but you are treating it more like a document store than a relationship database.
For my use case, JSONB support completely killed most NoSQL solutions.