The headline is xpath_array + UNNEST: it turns a column of XML documents into shredded rows, one per matching node, in a single SQL statement: ...
eXide is a web-based XQuery IDE built around CodeMirror 6. It is tightly integrated with the eXist-db native XML database. eXide is included in eXist-db distributions ...