Under working with JSON section in the book it is mentioned as
"The equivalent in SQL would be
jsonDF.selectExpr("json_tuple(jsonString, '$.myJSONKey.myJSONValue[1]') as column").show(2)"
but it is not a SQL syntax at first . could you please check and let us know the equivalent SQL expression of JSON transformation.