This document describes the support in SQL for JavaScript Object Notation.<\/p>\n
This document discusses the following features of the SQL language:<\/p>\n
Storing JSON data.<\/p>\n<\/li>\n
Publishing JSON data.<\/p>\n<\/li>\n
Querying JSON data.<\/p>\n<\/li>\n
SQL\/JSON data model and path language.<\/p>\n<\/li>\n<\/ul>\n
| PDF Pages<\/th>\n | PDF Title<\/th>\n<\/tr>\n | ||||||
|---|---|---|---|---|---|---|---|
| 2<\/td>\n | undefined <\/td>\n<\/tr>\n | ||||||
| 5<\/td>\n | Contents <\/td>\n<\/tr>\n | ||||||
| 8<\/td>\n | Tables <\/td>\n<\/tr>\n | ||||||
| 10<\/td>\n | Figures <\/td>\n<\/tr>\n | ||||||
| 11<\/td>\n | Foreword <\/td>\n<\/tr>\n | ||||||
| 13<\/td>\n | Introduction <\/td>\n<\/tr>\n | ||||||
| 15<\/td>\n | 1 Scope <\/td>\n<\/tr>\n | ||||||
| 16<\/td>\n | 2 Normative references <\/td>\n<\/tr>\n | ||||||
| 17<\/td>\n | 3 Terms and definitions <\/td>\n<\/tr>\n | ||||||
| 20<\/td>\n | 4 JavaScript Object Notation (JSON) 4.1 Context for JSON 4.2 What is JSON? <\/td>\n<\/tr>\n | ||||||
| 21<\/td>\n | 4.3 Representations of JSON data 4.3.1 Introduction to representations of JSON data 4.3.2 Avro <\/td>\n<\/tr>\n | ||||||
| 22<\/td>\n | 4.3.3 BSON 4.4 Schemas 4.4.1 JSON schemata and validity <\/td>\n<\/tr>\n | ||||||
| 23<\/td>\n | 4.4.2 Avro schemata 4.4.3 BSON schemata <\/td>\n<\/tr>\n | ||||||
| 24<\/td>\n | 4.5 Why does JSON matter in the context of SQL? What is JSON\u2019s relationship to NoSQL? <\/td>\n<\/tr>\n | ||||||
| 25<\/td>\n | 4.6 Use cases for JSON support in SQL 4.6.1 Introduction to the use cases 4.6.2 JSON data ingestion and storage 4.6.3 JSON data generation from relational data <\/td>\n<\/tr>\n | ||||||
| 26<\/td>\n | 4.6.4 Querying JSON as persistent semi-structured data model instances 4.7 What features address those use cases? 4.7.1 Addressing the use cases 4.7.2 Storing JSON data in an SQL table 4.7.3 Generating JSON in an SQL query <\/td>\n<\/tr>\n | ||||||
| 27<\/td>\n | 4.7.4 Querying JSON data in SQL tables using SQL <\/td>\n<\/tr>\n | ||||||
| 28<\/td>\n | 5 The SQL\/JSON data model 5.1 Introduction to the SQL\/JSON data model <\/td>\n<\/tr>\n | ||||||
| 29<\/td>\n | 5.2 SQL\/JSON items 5.2.1 Definition of SQL\/JSON items <\/td>\n<\/tr>\n | ||||||
| 30<\/td>\n | 5.2.2 Atomic values <\/td>\n<\/tr>\n | ||||||
| 31<\/td>\n | 5.2.3 SQL\/JSON arrays 5.2.4 SQL\/JSON objects 5.3 SQL\/JSON sequences <\/td>\n<\/tr>\n | ||||||
| 32<\/td>\n | 5.4 Parsing JSON 5.5 Serializing JSON <\/td>\n<\/tr>\n | ||||||
| 33<\/td>\n | 6 SQL\/JSON functions 6.1 Introduction to SQL\/JSON functions 6.2 Handle JSON using built-in functions 6.3 JSON API common syntax 6.3.1 Introduction to JSON API common syntax <\/td>\n<\/tr>\n | ||||||
| 34<\/td>\n | 6.3.2 JSON value expression 6.3.3 Path expression 6.3.4 PASSING clause <\/td>\n<\/tr>\n | ||||||
| 35<\/td>\n | 6.3.5 JSON output clause 6.3.6 ON ERROR and ON EMPTY syntax <\/td>\n<\/tr>\n | ||||||
| 36<\/td>\n | 6.4 Query functions 6.4.1 The four query functions 6.4.2 JSON_EXISTS <\/td>\n<\/tr>\n | ||||||
| 39<\/td>\n | 6.4.3 JSON_VALUE <\/td>\n<\/tr>\n | ||||||
| 43<\/td>\n | 6.4.4 JSON_QUERY <\/td>\n<\/tr>\n | ||||||
| 47<\/td>\n | 6.4.5 JSON_TABLE 6.4.5.1 Introduction to JSON_TABLE <\/td>\n<\/tr>\n | ||||||
| 48<\/td>\n | 6.4.5.2 COLUMNS clause that is not nested <\/td>\n<\/tr>\n | ||||||
| 50<\/td>\n | 6.4.5.3 Nested COLUMNS clause <\/td>\n<\/tr>\n | ||||||
| 51<\/td>\n | 6.4.5.4 PLAN clause <\/td>\n<\/tr>\n | ||||||
| 55<\/td>\n | 6.4.6 Conformance features for query operators <\/td>\n<\/tr>\n | ||||||
| 57<\/td>\n | 6.5 Constructor functions and IS JSON predicate 6.5.1 Tables used to illustrate constructor functions and the IS JSON predicate <\/td>\n<\/tr>\n | ||||||
| 58<\/td>\n | 6.5.2 JSON_OBJECT <\/td>\n<\/tr>\n | ||||||
| 59<\/td>\n | 6.5.3 JSON_OBJECTAGG <\/td>\n<\/tr>\n | ||||||
| 60<\/td>\n | 6.5.4 JSON_ARRAY <\/td>\n<\/tr>\n | ||||||
| 61<\/td>\n | 6.5.5 JSON_ARRAYAGG <\/td>\n<\/tr>\n | ||||||
| 63<\/td>\n | 6.5.6 IS JSON predicate 6.5.7 Handling of JSON nulls and SQL nulls <\/td>\n<\/tr>\n | ||||||
| 64<\/td>\n | 6.5.8 Conformance features for constructor functions <\/td>\n<\/tr>\n | ||||||
| 65<\/td>\n | 7 SQL\/JSON path language 7.1 Overview of SQL\/JSON path language <\/td>\n<\/tr>\n | ||||||
| 66<\/td>\n | 7.2 Objectives for the SQL\/JSON path language <\/td>\n<\/tr>\n | ||||||
| 67<\/td>\n | 7.3 Modes 7.3.1 Introduction to modes <\/td>\n<\/tr>\n | ||||||
| 68<\/td>\n | 7.3.2 Example of strict vs lax <\/td>\n<\/tr>\n | ||||||
| 70<\/td>\n | 7.4 Lexical issues <\/td>\n<\/tr>\n | ||||||
| 72<\/td>\n | 7.5 Syntax summary 7.6 Formal semantics and notational conventions <\/td>\n<\/tr>\n | ||||||
| 73<\/td>\n | 7.7 Primitive operations in formal semantics 7.7.1 Concatenation 7.7.2 unwrap() <\/td>\n<\/tr>\n | ||||||
| 74<\/td>\n | 7.7.3 wrap() 7.8 Mode declaration <\/td>\n<\/tr>\n | ||||||
| 75<\/td>\n | 7.9 7.9.1 Introduction to JSON path primaries 7.9.2 Literals <\/td>\n<\/tr>\n | ||||||
| 76<\/td>\n | 7.9.3 Variables <\/td>\n<\/tr>\n | ||||||
| 77<\/td>\n | 7.9.4 Parentheses 7.10 Accessors 7.10.1 Introduction to accessors <\/td>\n<\/tr>\n | ||||||
| 78<\/td>\n | 7.10.2 Member accessor <\/td>\n<\/tr>\n | ||||||
| 81<\/td>\n | 7.10.3 Member wildcard accessor <\/td>\n<\/tr>\n | ||||||
| 82<\/td>\n | 7.10.4 Element accessor <\/td>\n<\/tr>\n | ||||||
| 84<\/td>\n | 7.10.5 Element wildcard accessor <\/td>\n<\/tr>\n | ||||||
| 85<\/td>\n | 7.10.6 Sequence semantics of the accessors 7.11 Item methods 7.11.1 Introduction to item methods <\/td>\n<\/tr>\n | ||||||
| 86<\/td>\n | 7.11.2 type() 7.11.3 size() <\/td>\n<\/tr>\n | ||||||
| 87<\/td>\n | 7.11.4 Numeric item methods (double, ceiling, floor, abs) 7.11.5 datetime() 7.11.6 keyvalue() <\/td>\n<\/tr>\n | ||||||
| 89<\/td>\n | 7.12 Arithmetic expressions 7.12.1 Introduction to arithmetic expressions 7.12.2 Unary plus and minus <\/td>\n<\/tr>\n | ||||||
| 90<\/td>\n | 7.12.3 Binary operations 7.13 Filter expression 7.13.1 Introduction to filter expressions <\/td>\n<\/tr>\n | ||||||
| 91<\/td>\n | 7.13.2 true\/false and True\/False <\/td>\n<\/tr>\n | ||||||
| 92<\/td>\n | 7.13.3 null and Unknown 7.13.4 Error handling in filters <\/td>\n<\/tr>\n | ||||||
| 95<\/td>\n | 7.13.5 Truth tables <\/td>\n<\/tr>\n | ||||||
| 96<\/td>\n | 7.13.6 Comparison predicates <\/td>\n<\/tr>\n | ||||||
| 97<\/td>\n | 7.13.7 like_regex predicate <\/td>\n<\/tr>\n | ||||||
| 98<\/td>\n | 7.13.8 starts with predicate 7.13.9 exists predicate <\/td>\n<\/tr>\n | ||||||
| 100<\/td>\n | 7.13.10 is unknown predicate <\/td>\n<\/tr>\n | ||||||
| 101<\/td>\n | 7.14 Conformance features for SQL\/JSON path language <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Information technology. Guidance for the use of database language SQL – Support for JSON<\/b><\/p>\n |