This is the first step towards #47473. At a high level, we should create a new implementation of an exec.Factory and implement ConstructScan to return a TableReaderSpec directly. This behavior should be off by default. We might want to break down this issue further or expand once we've done a bit of investigation.