Always find it frustrating how tedious trees are in SQL. Like, relational db is in the name, so why is such a common pattern of relations so annoying to work with?