- [ ] subquery decorrelation - [ ] S3 select