But it's also impossible to use anything else if you're already committed to a SQL database. I think there are better ways to model real data than in tables.
Discussion
Understood, ived used some mongo + unstructured data but most of my work at least has been in SQL. Mostly financial
Yeah, and if I had to pick some data that is great in a table, it's financial ledgers. They've been in tables for millenia. It works and it works really well.
But also, if I were writing a financial application, I'd use Neo4j. A database where the native data structure itself lets you literally "follow the money" anywhere it flows would be amazing.