Cannot use JSON_VALUE function

[arnaudbriche]

(you don't have to strictly follow this form)

Describe the unexpected behaviour A clear and concise description of what works not as it is supposed to.

How to reproduce

SELECT JSON_VALUE('{"key": "value"}', '$.key')

• Which ClickHouse server version to use
• Which interface to use, if matters

chdb

• Non-default settings, if any
• CREATE TABLE statements for all tables involved
• Sample data for all these tables, use clickhouse-obfuscator if necessary
• Queries to run that lead to unexpected result

Expected behavior A clear and concise description of what you expected to happen.

Error message and/or stacktrace

chdb.ChdbError: Code: 48. DB::Exception: Functions JSON* are not supported: In scope SELECT JSONExtract('{"key": "value"}', 'Tuple(String)'), JSON_VALUE('{"key": "value"}', '$.key'). (NOT_IMPLEMENTED)

Additional context Add any other context about the problem here.