Use JSON in Sql Server 2016

sql_server_json_example.sql

declare @json varchar(2000) = '{
  "colors": [
    {
      "color": "black",
      "category": "hue",
      "type": "primary",
      "code": {
        "rgba": [255,255,255,1],
        "hex": "#000"
      }
    },
    {
      "color": "white",
      "category": "value",
      "code": {
        "rgba": [0,0,0,1],
        "hex": "#FFF"
      }
    },
    {
      "color": "red",
      "category": "hue",
      "type": "primary",
      "code": {
        "rgba": [255,0,0,1],
        "hex": "#FF0"
      }
    }]}';


SELECT *
FROM OPENJSON(@json,'$.colors')  
WITH (
color   varchar(200)   '$.color',
hex varchar(100) '$.code.hex'
 )