SELECT * 

FROM JSON_TABLE(

   '[

        {"first_name": "John", "first_name": "Jonathan", "last_name": "Smith", "email": "john.smith@example.com"},

        {"first_name": "Jon", "last_name": "Smith", "email": "jon.smith@example.com"},

        {"first_name": "Johnny", "last_name": "Smith", "email": "john.smith@example.com"}

    ]', 

'$[*]'

COLUMNS(

   rowid FOR ORDINALITY,

   first_name VARCHAR(10) PATH '$.first_name' ERROR ON ERROR,

   last_name  VARCHAR(10) PATH '$.last_name' ERROR ON ERROR,

   email VARCHAR(50) PATH '$.email' ERROR ON ERROR

)

) AS people;

+-------+------------+-----------+------------------------+

| rowid | first_name | last_name | email                  |

+-------+------------+-----------+------------------------+

|     1 | John       | Smith     | john.smith@example.com |

|     2 | Jon        | Smith     | jon.smith@example.com  |

|     3 | Johnny     | Smith     | john.smith@example.com |

+-------+------------+-----------+------------------------+