sql: allow atomic name swaps

[cockroach-teamcity]

Exalate commented:

cockroachdb/cockroach#70334 --- Release note (sql change): It's now possible to swap names (for tables, etc.) in the same transaction. For example: CREATE TABLE foo(); BEGIN; ALTER TABLE foo RENAME TO bar; CREATE TABLE foo(); COMMIT; Previously, we'd be getting a "relation ... already exists" error.

Jira Issue: DOC-1676

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB docs!