The same use case it originally had? "Here's some incomplete data, show me all possible paths it could take."

SQL is fine if there are interlinks supporting the direction of your search. But those relationships frequently end up one-way, unless the architect both fights for it, and actually exists.