Turn array elements into result rows.
Section: Update and expand JSON
Expand an array with json_each
sql
sql
SELECT value AS tag
FROM json_each('["sqlite", "json", "fts"]');Explanation
`json_each` is a table-valued function and belongs in the FROM clause.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Update and expand JSON