[simonw]

I did some research recently to figure out exactly how the path syntax used by the various SQLite JSON functions and operators works: https://til.simonwillison.net/sqlite/json-extract-path

[xtreak29]

Thanks, your sqlite-utils and other libraries have been very helpful.