LLM has issued a bug fix release addressing a breakage caused by Homebrew now shipping SQLite 3.54.1, which changed how json_object handles subqueries: a query returning {"a":[1]} in 3.54.0 now returns {"a":"[1]"} in 3.54.1. D. Richard Hipp confirmed the new behavior is correct per SQLite documentation, since (SELECT json_array(...)) returns SQL text, not JSON. The workaround wraps the subquery in json().
No score is assigned. Sources and their independence are shown in the citation chain below.