Turn article sections into rows
Compare the topics covered by reports, product guides, or research articles without reading every page manually.
SQL
WITH selected_docs AS (
SELECT DISTINCT capture_id
FROM captures
WHERE startsWith(url, 'https://example.com/research/')
AND capture_id IS NOT NULL
ORDER BY capture_id
LIMIT 20
)
SELECT s.capture_id, m.node_index,
node_text(s.capture_id, m.node_index) AS heading
FROM selected_docs AS s
CROSS JOIN LATERAL query_selector_all(s.capture_id, 'article h2') AS m
ORDER BY s.capture_id, m.node_index;