SQL Server: use the new modify method for partial update on the json type
Open
area-json
area-perf
area-save-changes
area-sqlserver
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
Our update pipeline currently uses JSON_MODIFY() to perform partial updates inside JSON documents. SQL Server 2025 is introducing a new `modify` method that can do the same in a more efficient way ([docs](https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type?view=azuresqldb-current#modify-method)).
Note that partial updates aren't yet implemented for complex JSON, only owned (#36429), though this is orthogonal.
/cc @AndriySvyryd
Contributor guide
Assessment
This issue has not been assessed yet.