Feature Request: Add CAST to list of supported ClickHouse functions

[ordehi]

Feature request

Is your feature request related to a problem?

We have created a view in SQL editor by selecting properties (unaltered from events table). When this view is created, properties is recognized as a string (not JSON), which is causing issues when using PostHog Query API.

Describe the solution you'd like

• It seems that the CAST function is also not available to cast the field as JSON: https://clickhouse.com/docs/sql-reference/data-types/newjson#using-cast-with-json

Describe alternatives you've considered

• Mapping properties, which doesn't work due to type restrictions.

Additional context

From: https://posthoghelp.zendesk.com/agent/tickets/26780

Debug info

null