ai-context-engineering/time-range-file-detail.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
      'Ingest Health' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/ingest-health.sql' as link;
     
      select 'Files' as title, '#' as link;
     
      SELECT 'title' AS component, 'File Details' AS contents;
     
      -- First card for accordion (frontmatter details)
      SELECT 'html' AS component,
      '<details open>
      <summary>Frontmatter details</summary>
      <div>' AS html;
     
      SELECT 'card' AS component, 1 as columns;
     
      SELECT
      '
 **Title** : ' || a.title AS description_md,
      '
 **Summary** : ' || a.frontmatter_summary AS description_md,
      '
 **Lifecycle** : ' || a.frontmatter_lifecycle AS description_md,
      '
 **Product name** : ' || a.frontmatter_product_name AS description_md,
      '
 **Provenance source uri** : ' || a.frontmatter_provenance_source_uri AS description_md,
      '
**Provenance dependencies**:
' ||
  ifnull((
    SELECT group_concat('- ' || value, char(10))
    FROM json_each(a.frontmatter_provenance_dependencies)
  ), 'None')
  AS description_md,
      '
 **Reviewers** : ' || a.frontmatter_reviewers AS description_md,
      '
 **Product features** : ' || a.frontmatter_product_features AS description_md,
      '
 **Merge group** : ' || a.frontmatter_merge_group AS description_md
      FROM ai_ctxe_uniform_resource_frontmatter_view a
      WHERE a.uniform_resource_id = $uniform_resource_id;
     
      SELECT 'html' AS component, '</div></details>' AS html;
     
      SELECT 'card' AS component, 1 as columns;
     
      SELECT
      '
' || p.body_text AS description_md
      FROM ai_ctxe_uniform_resource_all_files p
      WHERE p.uniform_resource_id = $uniform_resource_id;