Column Settings

[serprex]

For the table box in the UI's table picker for CDC create flow:

• Have a field for selecting ReplacingMergeTree vs MergeTree
• Number field for each column. This will be used to order the columns in the ORDER BY clause while creating Clickhouse target tables

[serprex]

custom clickhouse types should only be accepted if matching [a-zA-Z0-9()_,]+

prevents Nested, along with rich JSON, but also prevents unresticted injection

[Amogh-Bharadwaj]

With PEERDB_NULLABLE set, we get the following error when creating the table:

Sorting key contains nullable columns, but merge tree setting `allow_nullable_key` is disabled

Do we want to set allow_nullable_key or exclude the column in ORDER BY if it is Nullable? Or something else

[serprex]

For now we can leave it as unsupported