I wrote some large TCL applications between 2005 and 2015 that used an in-memory SQLite database to store the bulk of the data model. Indeed, having a relational model was a huge win...except for some patterns (tree structures, certain kinds of polymorphism) where it was an enormous pain.
Why the relational model is better than objects
https://www.cell-lang.net/relations.html