CODE EXAMPLE FOR JAVASCRIPT

SQL JSON_EXTRACT

select JSON_UNQUOTE(JSON_EXTRACT(base, '$.scope')) as scope from t_name