llm 0.37.3 Simon Willison released llm 0.37.3, a bug-fix release of the LLM command-line tool, after Homebrew began shipping SQLite 3.54.1, which broke LLM's logging code. SQLite's 3.54.1 change means a subquery such as (select json_array(1)) now returns SQL text rather than JSON, so json_object('a', (select json_array(1))) yields {"a":"[1]"} instead of {"a":[1]}; SQLite creator D. Richard Hipp said "That was a bug fix" and that 3.54.0 was the buggy version. The documented workaround wraps the subquery in json(), as in select json_object('a', json((select json_array(1)))). Release: llm 0.37.3 https://github.com/simonw/llm/releases/tag/0.37.3 A bug fix release for LLM https://llm.datasette.io , mainly to cover a problem with the most recent Homebrew package of the software. Homebrew now ships the latest SQLite, 3.54.1 https://www.sqlite.org/releaselog/3 54 1.html , which includes a fix https://sqlite.org/bugs/info/2026-10-12T13:52:22Z that broke LLM's logging code https://github.com/simonw/llm/issues/1879 . Short version: in SQLite 3.54.0 the following SQL: select json object 'a', select json array 1 Returns this: {"a": 1 } But in 3.54.1 the same query returns this: {"a":" 1 "} According to D. Richard Hipp https://sqlite.org/forum/forumpost/dff1a343157e422f : That was a bug fix. Per the documentation, SELECT json array ... returns SQL text, not JSON. Hence the 3.54.1 behavior is correct and 3.54.0 was a bug. The workaround looks like this: select json object 'a', json select json array 1 Tags: llm https://simonwillison.net/tags/llm , webassembly https://simonwillison.net/tags/webassembly , sqlite https://simonwillison.net/tags/sqlite , generative-ai https://simonwillison.net/tags/generative-ai , ai https://simonwillison.net/tags/ai , llms https://simonwillison.net/tags/llms , d-richard-hipp https://simonwillison.net/tags/d-richard-hipp