Topic
JSON
2 posts from the Query.Farm blog tagged JSON.
DuckDB
JSON Schema for DuckDB 2.0: validate a column without losing the bad rows
JSON Schema for DuckDB 2.0 adds boolean validation, structured errors, and support through draft 2020-12, with explicit format checks and safer regular expressions.
4 min read
DuckDB
JSONata for DuckDB 2.0: expressions that can be stopped
JSONata for DuckDB 2.0 adds evaluation timeouts, depth limits, syntax validation, and compiled-expression caching, with RE2 patterns and correct per-row randomness.
4 min read