[YSQL] Eliminate Catalog Version Mismatch error

[m-iancu]

Jira Link: DB-2367
Currently, DDL operations always conflict with concurrent DML transactions and can lead to a Catalog Version Mismatch error.
This will be fixed in two stages.

Stage 1

Minimize the error cases by only conflicting when the DDL and the DML transaction affect the same data (tablets).

Status	Feature	Comments
✅	DROP TABLE	#7325
✅	ALTER TABLE ADD/DROP column	#7327
✅	Make Catalog Version Mismatch a retryable error	#8597
✅	ALTER TABLE other cases	#8398

Stage 2

For conflicts (DDL and DML transaction affect same data) wait instead of throwing a "Catalog Version Mismatch" error.

Status	Feature	Comments
⬜️	DDL operations should wait for conflicting transactions to finish	May depend on #5683