How to extract value from a generic JSON doc

SQL++
1

I have a json structure which has the following structure, the fields has list of names and values (sort of key value pair). How do I extract the value for a specific field where name = ‘abc’, I would expect the value of output to return as “answer1”. Appreciate your help !

    {
        "type": "sample_test_record",
        "fields": [
          {
            "name": "abc",
            "val": "answer1"
          },
          {
            "name": "xyz",
            "val": "answer2"
          }
        ]
      }