JSON functions

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

jOOQ 3.12 introduced support for the org.jooq.JSON and org.jooq.JSONB types, which are used to wrap string based JSON documents in a type safe way. With these types, there are also a few standard JSON functions that have been added to the API. This section describes scalar functions, but there are also conditions, aggregate functions, and table valued functions for JSON usage.

Most functions are overloaded with a JSON and JSONB variant to make the distinction explicit for dialects where this matters. For simplicity, and because most dialects do not make a distinction, this manual will only document the JSON version of each function.

Table of contents

3.11.18.1.

JSON_ARRAY

3.11.18.2.

JSON_INSERT

3.11.18.3.

JSON_KEYS

3.11.18.4.

JSON_OBJECT

3.11.18.5.

JSON_REMOVE

3.11.18.6.

JSON_REPLACE

3.11.18.7.

JSON_SET

3.11.18.8.

JSON_VALUE

3.11.18.9.

JSON array element access with -> or ->>

3.11.18.10.

JSON object attribute access with -> or ->>