Why is there an error FUNCTION stq_table.JSON_VALUE does not exist?

Question

SQL

Hello!

There is a table, one of the columns of which contains data in json format - the additional column .
I'm trying to display all "userfullname" values.

SELECT JSON_VALUE(additional,'$.userfullname') AS fullname
FROM `stq_user_info`

Unfortunately, I can't find an answer to this error on the Internet. I understand what this function means, but there are a lot of solutions on the stack just with it. Please explain what could be the reason? Or did I somehow write the request incorrectly?

Answer 1

I'm dumb. json_extract function