Changelog category (leave one):

• New Feature

Changelog entry (a user-readable short description of the changes that goes into CHANGELOG.md):

Add setting type_json_skip_invalid_typed_paths to disable exceptions for inserts/type casts to JSON type when input JSON cannot be cast to explicit typed paths in JSON type. Falls back to null/zero value of typed path. Closes #86917

Documentation entry for user-facing changes

• Documentation is written (mandatory for new features)

Details

Adds type_json_skip_invalid_typed_paths setting so you can gracefully handle unknown input data when you want to always have a specific type for a given path:

select '{"some_field": "asdf", "foo": 1}'::JSON(some_field UInt64) SETTINGS type_json_skip_invalid_typed_paths=1
-- result: {"some_field: 0, "foo": 1}