I find it seriously irritating when silly limitations like this in a framework corner you into bad data design. Frameworks by their very definition are not mea

I find it seriously irritating when silly limitations like this in a framework corner you into bad data design. Frameworks by their very definition are not meant to cover 100% of use cases. They cover the 80% of issues that can be solved without composite keys, or those where the overhead in not having the correct design is negligible. Perhaps in these cases you shouldn't be forcing the framework into a position it can't fit.