Documentation databases operate in tree structures - MongoDB - ZODB - Others - This is also how disk file systems operate You access items by their path, i

Documentation databases operate in tree structures - MongoDB - ZODB - Others - This is also how disk file systems operate You access items by their path, instead of id. Also path is relevant how the data is physically stored, fetching nearby data being cheaper. To work with this kind of data in SQL you need to construct recursive CTE queries. While it’s possible, it is a bit akward sometimes.