feat(optimizer): runtime check for scalar subquery in batch queries

feat(optimizer): runtime check for scalar subquery in batch queries #27965