ur/uniform-resource-imap-folder.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
  'Uniform Resource' as title,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ur/index.sql' as link;
SELECT
  'Uniform Resources (IMAP)' as title,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ur/uniform-resource-imap-account.sql' as link;
SELECT
  'Folder' as title,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ur/uniform-resource-imap-folder.sql?imap_account_id=' || $imap_account_id:: TEXT as link;
SELECT
  'title' as component,
  (SELECT email FROM uniform_resource_imap WHERE ur_ingest_session_imap_account_id = $imap_account_id::TEXT) as contents;

--Display uniform_resource table with pagination
  SELECT 'table' AS component,
  'Uniform Resources' AS title,
    "Size (bytes)" as align_right,
    TRUE AS sort,
      TRUE AS search,
        TRUE AS hover,
          TRUE AS striped_rows,
            TRUE AS small,
              'folder' AS markdown;
  SELECT '[' || folder_name || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ur/uniform-resource-imap-mail-list.sql?folder_id=' || ur_ingest_session_imap_acct_folder_id || ')' AS "folder"
    FROM uniform_resource_imap
    WHERE ur_ingest_session_imap_account_id = $imap_account_id:: TEXT
    GROUP BY ur_ingest_session_imap_acct_folder_id
    ORDER BY uniform_resource_id;