In order to support multi-region serverless, DistSQL should create locality-aware distributed plans. This would create table readers on SQL instances located in regions/zones where data is on a local KV node, or on the closest possible SQL instances.
Dependencies:
JIRA: https://cockroachlabs.atlassian.net/browse/CRDB-14202
Jira issue: CRDB-15554
Epic CRDB-14202