I have json stored in a string field. There is a board_code node in the json. The sql to select just the board_code value out of those strings is:

SELECT JSON_VALUE(ColumnName, ‘$.board_code’) AS BoardCode FROM TableName;