[ahdh8f4hf4h8]

Honestly, object oriented design is the anti-pattern here. Almost none of the benefits promised in the 1990's and 2000's have come to pass, and for most applications type hierarchies are of little help.

For most applications, having a really good relational data model, and controlling data updates through a service/microservice will give most of the benefits of "object oriented" design without any of the drawbacks. The service will act as a "live object", data integrity will be preserved, data science modeling will be easy, and the application can be designed using whatever tomorrow's preferred platform of the day is, or even some low code stuff for simple applications.