Comment by wtetzner

7 years ago

SQL:2016 includes support for JSON: https://en.wikipedia.org/wiki/SQL:2016

Interesting, I wonder which databases actually implement SQL:2016 (and JSON as standardized). JSON support in Postgres predates SQL:2016 in any case.

  • I think Oracle does. My impression is that PostgreSQL sort-of "invented" JSON support in the db, then Oracle (and probably others) added JSON support with a different syntax, and then Oracle got their version defined into the SQL standard. I'm half-guessing here, but it's based on what I've gleaned from Markus Winand's [0] excellent compatibility tables in his slides [1].

    [0] https://modern-sql.com/

    [1] https://modern-sql.com/slides/ModernSQL-2019-05-08.pdf, for example

    (Edited for formatting.)