It's not currently possible, partly because it complicates the deployment model quite a bit. Dynamically bringing SQL pods up and down requires a technology like Kubernetes. It takes some serious operational know-how to keep it running smoothly, which is why we thought it would be perfect for a managed Cloud service.
What would be your company's reasons for wanting this available in self-hosted CRDB? What kinds of use cases would it address for you?