lie/profile.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
    SELECT
        COALESCE(abbreviated_caption, caption) AS title,
        COALESCE(url, path) AS link,
        parent_path, 0 AS level,
        namespace
    FROM sqlpage_aide_navigation
    WHERE namespace = 'prime' AND path='lie/profile.sql'
    UNION ALL
    SELECT
        COALESCE(nav.abbreviated_caption, nav.caption) AS title,
        COALESCE(nav.url, nav.path) AS link,
        nav.parent_path, b.level + 1, nav.namespace
    FROM sqlpage_aide_navigation nav
    INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,      
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link        
FROM breadcrumbs ORDER BY level DESC;
              -- not including page title from sqlpage_aide_navigation
              

              SELECT 'title' AS component, (SELECT COALESCE(title, caption)
    FROM sqlpage_aide_navigation
   WHERE namespace = 'prime' AND path = 'lie/profile.sql/index.sql') as contents;
    ;
select
  'text'              as component,
  'The Source List page provides a streamlined view of all collected content sources. This page displays only the origins of the content, such as sender information for email sources, making it easy to see where each piece of content came from. Use this list to quickly review and identify the various sources contributing to the curated content collection.' as contents;

select 
  'datagrid' as component;
select 
    'Name' as title,
    full_name as description
 FROM linkedin_profile;
select
    'Address' as title,
    address as description
FROM linkedin_profile;
select
    'Birth Date' as title,
    birth_date as description
FROM linkedin_profile;

-- Dashboard count
select
  'card' as component,
  3      as columns;
SELECT
    'Connection'  as title,
    '## '||connection_count||' ##' as description_md,
    TRUE                  as active,
    'home-link'       as icon,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/connection.sql' as link
FROM linkedin_connection_count;

SELECT
    'Skills'  as title,
    '## '||total_skills||' ##' as description_md,
    TRUE                  as active,
    'bulb'       as icon,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/skills.sql' as link
FROM linkedin_top_skills_count;

SELECT
    'Employment Timeline'  as title,
    '## '||time_line_count||' ##' as description_md,
    TRUE                  as active,
    'baseline-density-small'       as icon,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/time_line.sql' as link
FROM linkedin_employment_timeline_count;

select 
  'card' as component,
  2      as columns;
select 
  'Learnings' as description_md,
  TRUE                  as active,
  'book'       as icon,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/learning.sql' as link;
select
  'Company Follows' as description_md,
  TRUE                  as active,
  'building'       as icon,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/company_follows.sql' as link;

select 
'title'   as component,
'Education' as contents;

SELECT 'table' AS component;
SELECT
 *
FROM linkedin_profile_education;