Inner Joins

Extended the SQL dialect of Oracle NoSQL Database to support inner joins among tables in the same table hierarchy. Two or more tables in the same hierarchy may be joined in a query.

Support of JSON Merge Patch

Extended the SQL UPDATE statement to support updates of JSON fields via the JSON merge patch specification (described here).

Support for Updating Multiple Records in a Query

An update query can now update multiple records in a single transaction if the query predicate contains a shard key.