Postgres JSONB functions

PostgreSQL has excellent support for "native" JSON storage, almost as a document db, 
while SQL extension syntax is custom, so it takes come time to get used to.

PostgreSQL: Documentation: 9.5: JSON Functions and Operators

How to update objects inside JSONB arrays with PostgreSQL