insert a json array directly into into sqlite with sqlite-utils.
echo '{"name": "Cleo", "age": 4}' | sqlite-utils insert dogs.db dogs -
sqlite-utils command-line tool - sqlite-utils
!https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data