SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.

Powershell's "ConvertFrom-Json" correctly handles it in both cases, dumping either 1 or 2+ items into an array, which I understand is more loosely typed. It depends on your definition of "correct".

What is JSON (JavaScript Object Notation)? JSON (JavaScript Object Notation) is a text-based, human-readable data interchange format used to exchange data between web clients and web servers. The ...