In practice most of the constraints are pretty sensible though. You just need to think a bit about your query patterns.

It’s certainly not for all use cases, though.