This should be a constant time operation on most databases, because existing rows are not touched. However, if you have lots of properties that are not indexed

This should be a constant time operation on most databases, because existing rows are not touched. However, if you have lots of properties that are not indexed or directly queried, I suggest having a single JSON field for them.