ai_ctxe_uniform_resource_without_frontmatter

Column	Type
uniform_resource_id	VARCHAR
uri	TEXT
created_at	TIMESTAMPTZ
content	BLOB
uri:1	TEXT
nature	TEXT
filename	TEXT

SQL DDL

CREATE VIEW ai_ctxe_uniform_resource_without_frontmatter AS

SELECT 
    ur.uniform_resource_id,
    ur.uri,
    
    ur.created_at,
  
    ur.content,
    ur.uri,
    ur.nature,
    fs.file_basename as filename
FROM uniform_resource ur
JOIN
  ur_ingest_session_fs_path_entry fs
  ON fs.uniform_resource_id = ur.uniform_resource_id
WHERE ur.deleted_at IS NULL
        AND (frontmatter IS NULL OR LENGTH(TRIM(frontmatter)) = 0)