ai-context-engineering/merge-group.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
      'Merge Groups' as title;
       SELECT 'title'AS component, 
     'Merge group' as contents;
      SELECT 'text' as component,
'This page displays all defined merge groups for AI context engineering prompts. Each group represents a collection of related prompts that can be explored further by clicking on the group name.' as contents;

     
      SELECT
      'table' as component,
      TRUE AS sort,
      TRUE AS search,
      'merge_group' as markdown;
     
      SELECT
      '['||merge_group||']('||sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/merge-group-detail.sql'||'?uniform_resource_id='||uniform_resource_id||')' as merge_group,
      title as 'title',
      uri as 'uri'
     
      FROM ai_ctxe_uniform_resource_prompts
      WHERE merge_group IS NOT NULL
      GROUP BY merge_group
      ORDER BY merge_group;