Post AYbainZQrUDyFcXsg4 by simon@fedi.simonwillison.net
 (DIR) More posts by simon@fedi.simonwillison.net
 (DIR) Post #AYbainZQrUDyFcXsg4 by simon@fedi.simonwillison.net
       2023-08-11T01:07:49Z
       
       0 likes, 0 repeats
       
       New plugin for sqlite-utils: sqlite-utils-jq, which adds a jq(document, expression) function for running JQ inside of SQL queries https://github.com/simonw/sqlite-utils-jq
       
 (DIR) Post #AYbbFzGoNq9o5pf4NM by LukeBrowell@mastodon.scot
       2023-08-11T01:14:03Z
       
       0 likes, 0 repeats
       
       @simon can one use it for joins?
       
 (DIR) Post #AYbdKDBimLpuKEQGB6 by simon@fedi.simonwillison.net
       2023-08-11T01:37:14Z
       
       0 likes, 0 repeats
       
       @LukeBrowell you could combine it with the json_each() to turn JSON returned by jq() into a table-like thing that you could then join against