[Feature] Support operator `->`, `->>` for JSON Functions

[lucienlgl]

Search before asking

• I had searched in the issues and found no similar issues.

Description

Is there any plan to support these two operators in the same way as MySQL does?

->: Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT().
->>: Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()).

Use case

We can refer to the MySQL documentation instead of providing separate examples.

->: https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html#operator_json-column-path
->>: https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html#operator_json-inline-path

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct