Chapter 4
Using JSON with SQL
IN THIS CHAPTER
Translating JSON-formatted data to SQL-formatted data, and vice versa
The SQL/JSON data model
SQL/JSON functions
SQL:2023 JSON enhancements
Just as XML is a data interchange format for transmitting data from one platform to a different incompatible platform, JavaScript Object Notation (JSON) is another such format that performs that function. JSON is specifically designed to transfer unstructured or semi-structured data from one NoSQL database to a different, incompatible NoSQL database. As large and ever-increasing amounts of data are being stored in the semi-structured databases addressed by NoSQL technology, the need to share that data with databases adhering to the highly structured relational technology that is the domain of SQL has become clear. The SQL:2016 specification officially brought JSON into the SQL world, and the SQL:2023 specification provides enhancements to further help us work with JSON data objects. First, I explain the basics of SQL and JSON using the SQL:2016 specifications. Then I show how the SQL:2023 enhancements ...
Get SQL All-in-One For Dummies, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
