Here's my thought on sqlite-utils command-line tool - sqlite-utils
insert a json array directly into into sqlite with sqlite-utils.
echo '{"name": "Cleo", "age": 4}' | sqlite-utils insert dogs.db dogs -
This post was a thought by Waylon Walker see all my thoughts at https://waylonwalker.com/thoughts