ClickHouse offers two main categories of JSON functions:

simpleJSON functions

Parse well-known JSON extremely fast.

JSONExtract functions

Parse ordinary JSON with full compatibility.