tem_task_summary

Column	Type
uniform_resource_id	TEXT
uri	TEXT
content	BLOB
task_id
title
status
created_date
updated_date
priority

SQL DDL

CREATE VIEW tem_task_summary AS
SELECT
    uniform_resource_id,
    uri,
    content,  -- full Markdown content
    json_extract(frontmatter, '$.id') AS task_id,
    json_extract(frontmatter, '$.title') AS title,
    json_extract(frontmatter, '$.status') AS status,
    json_extract(frontmatter, '$.created_date') AS created_date,
    json_extract(frontmatter, '$.updated_date') AS updated_date,
    json_extract(frontmatter, '$.priority') AS priority
FROM uniform_resource
WHERE uri LIKE '%task%'