My sqlite-utils tool can pipe JSON directly into a SQLite table, creating a table with the right schema if it doesn't exist yet: https://sqlite-utils.datasette.io/en/stable/cli.html#inserti...
The MSSQL equivalent would be DbaTools, in case anyone is looking.