not support pg json data as where conditions.

[LingangJiang]

I have a json string field (called udmap) in clickhouse, when I handle it as PG json usage (udmap::jsonb -> 'src_stage')::int8 = 1 in where conditions, then error:

SELECT * FROM event WHERE (udmap::jsonb -> 'src_stage')::int8 = 1

错误: clickhouse_fdw:Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 83: -> 'src_stage'), 'Nullable(Int64)') = 1)). Expected one of: NOT, AS, LIKE, AND, OR, IN, BETWEEN, alias, token, IS, NOT LIKE, NOT IN, GLOBAL IN, GLOBAL NOT IN, Comma, QuestionMark
QUERY:SELECT udmap FROM test_cdp.t_customer_event WHERE ((cast((CAST(udmap AS jsonb(0)) -> 'src_stage'), 'Nullable(Int64)') = 1))

[LingangJiang]

I'm very anxious to use this function, hope clickhouse_fdw can support PG json usage in where conditions, maybe it convert PG json some writing method to clickhouse json usage like https://clickhouse.tech/docs/en/sql-reference/functions/json-functions/