Recursive CTE SQL

recursive_cte.sql

WITH RECURSIVE NetworkCTE AS (
    -- Anchor part to select the starting node
    SELECT source_node,
            target_node
    FROM network_connections
    WHERE source_node = 'Paolo' -- Change this to get someone else's network
    
    UNION ALL
    
    -- Recursive part to select connected nodes
    SELECT nc.source_node,
            nc.target_node
    FROM network_connections nc
    JOIN NetworkCTE n ON nc.source_node = n.target_node
)

SELECT * FROM NetworkCTE;