https://dba.stackexchange.com/questions/239180/find-ancestry-from-json#comment471849_239206
@MichaelGreen i gave up trying to get a "handle for all possible pathing types" in sql server after a while from this question, but if the "in-general" concept still interests you at all, i had quite a bit of fun with it over on TA not too long ago - https://topanswers.xyz/nix?q=888