Once we have #91235 we should expand the grammar to support creating the tenant from a replication stream. The complete grammar should be:

CREATE TENANT <destination-name> FROM REPLICATION OF <source-name> ON <connection-strings>

This will replace the existing RESTORE TENANT $1 FROM REPLICATION STREAM FROM string_or_placeholder_opt_list opt_as_tenant_clause rule that we have today. Note, as part of this work we will want to persist the ingestion job ID in the tenant record. This coupling is necessary to know whether a tenant is being streamed into or not, and for future interactions such as DROP and ALTER that will use the tenant to resolve the ingestion job.

Jira issue: CRDB-21170

Epic CRDB-18749