# Reconciling JSON in DuckDB, One Patch at a Time

DevFeed: [Reconciling JSON in DuckDB, One Patch at a Time](<https://devfeed.tech/articles/reconciling-json-in-duckdb-one-patch-at-a-time-4792.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/18/reconciling-json.html>)

Author: {"picture" =\> "/images/blog/authors/mustafa\_khan\_atlan.jpg"}

Published: 2026-08-18T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [JSON](<https://devfeed.tech/topics/json.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [data](<https://devfeed.tech/topics/data.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [Python](<https://devfeed.tech/topics/python.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [data](<https://devfeed.tech/tags/data.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [extension](<https://devfeed.tech/tags/extension.md>), [json](<https://devfeed.tech/tags/json.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

DuckDB v2.0 expands its JSON extension with functions for computing inverse RFC 7396 merge patches, applying patches with skip-on semantics, canonicalizing key order, and recursively removing null-valued keys. The article demonstrates how these functions support JSON reconciliation in SQL and compares them with Python implementations using synthetic CDC events.

## Source excerpt

DuckDB v2.0 will ship JSON functions that allow you to easily apply JSON patches.