How do you model semi-structured data like JSON or XML in a relational or analytical database? What are the trade-offs between different approaches?

Sample answer preview

Semi-structured data like JSON, XML, and nested objects is increasingly common as data sources include APIs, event streams, and NoSQL databases. Modeling this data in relational and analytical systems requires balancing flexibility with query performance.