How can I convert JSON data to SQL format without writing a custom script?

Hi mathew0406​,
A Microsoft-supported option is to use SQL Server’s built-in JSON capabilities instead of relying on a third-party converter. With OPENJSON, you can convert JSON data into relational rows and columns, including nested objects, and use additional operations to handle nested arrays and related records. This allows you to process JSON directly in SQL without building a separate custom application, and then use the resulting tables for analysis and reporting. SQL Server also provides guidance on storing and working efficiently with large collections of JSON data.
Work with JSON Data in SQL Server - SQL Server | Microsoft Learn
Validate, Query, and Change JSON Data with Built-In Functions - SQL Server | Microsoft Learn
Store JSON Documents - SQL Server | Microsoft Learn

Thank you.