JSONArrayElements returns a FROM-clause table-function fragment that unnests a JSON text-array column into one row per element, plus the expression yielding each element's text value. Intended as a comma cross-join: `FROM items i, WHERE ...` selecting . SQLite: fromExpr "json
(column, alias string)
| 150 | // SQLite: fromExpr "json_each(i.tags) je", valueExpr "je.value" |
| 151 | // PostgreSQL: fromExpr "jsonb_array_elements_text(i.tags::jsonb) AS je(value)", valueExpr "je.value" |
| 152 | JSONArrayElements(column, alias string) (fromExpr, valueExpr string) |
| 153 | |
| 154 | // DateBucket returns a SQL expression that truncates an RFC3339 UTC |
| 155 | // timestamp TEXT column to the start of its bucket, as a sortable TEXT |