Ah, now I see your point. It looks like we need to add an ability to run an SQL query against an individual partition - this would have worked for your use-case the same way a Scan query works.
I wonder of anybody in the community with a deeper knowledge of query processing can estimate the complexity of this feature and create a ticket with a proper description.
