غدق الخير

WITH RECURSIVE maternal_tree AS (
  SELECT child.id, mother.generation + 1 AS generation,
         ARRAY[mother.id, child.id]::text[] AS path
  FROM family_members child
  JOIN family_members father ON father.id = child.parent_id
  JOIN family_members mother ON mother.id = child.mother_id
  WHERE father.is_external = TRUE
    AND mother.is_external = FALSE
  UNION ALL …

const canSeeSensitive =
  await hasAdminPermission(session, 'members:update');

const columns = canSeeSensitive
  ? `${PUBLIC_COLUMNS}, ${ADMIN_ONLY_COLUMNS}`
  : PUBLIC_COLUMNS;

const connector = member.gender === '⁨أنثى⁩' ? '⁨بنت⁩' : '⁨بن⁩';
return `${firstName} ${connector} ${fatherName}`;