remove futures::block_on when planning

[skyzh]

we can (1) collect all table scans from the plan node, (2) in the async context, retrieve the schema, and (3) remove async from schema inference.