Consider async API design

Don't want it to be simply the sync api but just with `.await` swapped in

Some reference from parquet:

- https://github.com/apache/arrow-rs/issues/1473
- https://github.com/apache/arrow-datafusion/issues/2205#issuecomment-1100069800