I ended up writing https://www.jvt.me/posts/2023/03/13/sqlite-json/ https://www.jvt.me/posts/2023/03/13/sqlite-json/ as a quick reference for myself, as I found

I ended up writing https://www.jvt.me/posts/2023/03/13/sqlite-json/ https://www.jvt.me/posts/2023/03/13/sqlite-json/ as a quick reference for myself, as I found I needed something more copy-paste able for my own needs, as well as the official docs