[Enhancement]: support element in json array function

[zhagnlu]

Is there an existing issue for this?

• [X] I have searched the existing issues

What would you like to be added?

support retrieve one element in json array just like array contains element,

Why is this needed?

No response

Anything else?

No response

[xiaocai2333]

json: {"x": [1,2,3,4]} expr: 1 in json["x"]

[xiaofan-luan]

seems to be a reasonable feature

[xiaofan-luan]

we decide to use array_contains instead of IN

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.