The legacy schema changer implemented ADD PRIMARY KEY NOT VALID in the exactly same way as
ADD PRIMARY KEY. The declarative schema changer should also follow the same behavior but maybe
send a notice to the user.

Jira issue: CRDB-24901