docs: Added json_object and json_group_array to permitted_sqlite3_functions list
What the developer wrote
Authored by ShahanaFarooqui
docs: Added json_object and json_group_array to permitted_sqlite3_functions list
What changed, and why it matters
This commit only updates two documentation/schema files to list two additional SQLite functions (`json_object` and `json_group_array`) as permitted. There is no code change, no behavior change, and no security-relevant change visible in the diff.
No security action required. Treat as routine documentation update.
Security signals we found
No strong security signals were identified.
Evidence from the diff
The diff modifies contrib/msggen/msggen/schema.json and doc/schemas/sql-template.json, appending json_object and json_group_array to the permitted_sqlite3_functions list. No runtime logic, parsing, authorization, or SQL handling code is changed. It is a documentation/schema synchronization commit.
Changed components
contrib/msggen/msggen/schema.jsondoc/schemas/sql-template.jsonInspect captured patch +6 / −2
diff --git a/contrib/msggen/msggen/schema.json b/contrib/msggen/msggen/schema.json
index 1ffc7faf..f61fdffa 100644
--- a/contrib/msggen/msggen/schema.json
+++ b/contrib/msggen/msggen/schema.json
@@ -32538,7 +32538,9 @@
"* time",
"* timediff",
"* total",
- "* unixepoch"
+ "* unixepoch",
+ "* json_object",
+ "* json_group_array"
],
"tables": [
"Note that the first column of every table is a unique integer called `rowid`: this is used for related tables to refer to specific rows in their parent. sqlite3 usually has this as an implicit column, but we make it explicit as the implicit version is not allowed to be used as a foreign key.",
diff --git a/doc/schemas/sql-template.json b/doc/schemas/sql-template.json
index eee7f8db..eb332746 100644
--- a/doc/schemas/sql-template.json
+++ b/doc/schemas/sql-template.json
@@ -107,7 +107,9 @@
"* time",
"* timediff",
"* total",
- "* unixepoch"
+ "* unixepoch",
+ "* json_object",
+ "* json_group_array"
],
"tables": [
"Note that the first column of every table is a unique integer called `rowid`: this is used for related tables to refer to specific rows in their parent. sqlite3 usually has this as an implicit column, but we make it explicit as the implicit version is not allowed to be used as a foreign key.",
Why this scored 15/100
Community notes
Notes can correct, qualify, or add evidence to the AI analysis. Every note shown here has been validated by a human moderator.
The AI analysis stands alone for now. Submit a note if you can add evidence or important context.