постгресс 

 

Hstore  -  с 2003  .  возможность работать с key value помойками

с 2014 появился jsonB

с 2008 появился json офицально

 

https://thebuild.com/presentations/json2015-pgconfus.pdf

 

 

 

• The SQL/JSON retrieval functions:
  * JSON_VALUE - Extract an SQL value of a predefined type from a JSON value.
  * JSON_QUERY - Extract a JSON text from a JSON text using an SQL/JSON path
  expression.
  * JSON_TABLE - Query a JSON text and present it as a relational table.
  * IS [NOT] JSON - test whether a string value is a JSON text.
  * JSON_EXISTS - test whether a JSON path expression returns any SQL/JSON items