Re:Cyclic dependencies are evil (2013)
by Too on Sunday January 31, 2021 @01:40AM
(#25976644)
Starting from the other end, what is missing in SQL to make it more general purpose?
[ Parent
| on HN ]
Generic foreign keys / Polymorphic relations. I.e. table Foo can either point to table Bar or table Xuul.
This type of relation shows up quite a bit, and either leads to application-level workarounds, or having to add many duplicate tables for the same "thing".