ai-context-engineering/file-without-frontmatter.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              -- not including breadcrumbs from sqlpage_aide_navigation
              -- not including page title from sqlpage_aide_navigation
              

              
      select
      'breadcrumb' as component;
     
      select
      'Home' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' as link;
     
      select
      'AI Context Engineering Overview' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/index.sql' as link;
     
      select
      'Risk' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/risk.sql' as link;
     
      Select 'Files' as title, '#' as link;
      SELECT 'text' as component,
'This page lists ingested files that are missing frontmatter metadata. These files may require manual inspection or correction to be fully processed and included in the AI context engineering pipeline.' as contents;

     
      select
      'table' as component,
      TRUE AS sort,
      TRUE AS search,
      'filename' as markdown;
     
      select
      '[' || filename || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/file-detail-without-frontmatter.sql' || '?uniform_resource_id=' || uniform_resource_id || ')' as "filename",
      uri as "URI",
      nature as "Nature"
      from ai_ctxe_uniform_resource_transformed_resources_cleaned;