By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have it too by querying specific values quickly.
(The common phrase is to “have your cake and eat it too”, but did you ever think about how that’s backwards, and it doesn’t make any sense? It actually makes a lot more sense in the opposite order – as in, eat your cake and have it too – because that represents the best-of-both-worlds scenario. Have your cake and eat it too implies