Method JSONArrayElements

internal/store/dialect.go:113–113

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)

	// SQLite:   fromExpr "json_each(i.tags) je",                                valueExpr "je.value"
	// PostgreSQL: fromExpr "jsonb_array_elements_text(i.tags::jsonb) AS je(value)", valueExpr "je.value"
	JSONArrayElements(column, alias string) (fromExpr, valueExpr string)

	// DateBucket returns a SQL expression that truncates an RFC3339 UTC
	// timestamp TEXT column to the start of its bucket, as a sortable TEXT