@Cory Grinstead subquery optimization PR ready for review (need to add more tests but code is ready). Would be happy to hop on a call to walk through it as well if you'd like! https://github.com/Eventual-Inc/Daft/pull/3536