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 ...