mwish

Will invite @emkornfield @pitrou for comment Though style is a bit weird ( Maybe we should also support output to arrow-fs, so that we can extract a new footer from...

Will merge this, lets' adding test in another pr. So sorry for delaying

cc @wgtmac @pitrou

> If might be useful to have multiple row groups. Currently, we're not able to create file with different sort-props in multiple row-groups. Should I first implement that or just...

@wgtmac @pitrou I've change to use 2 row-groups with same data. Pr description is changed for this

I would merge this first. Feel free to edit or overwrite this if has any issue on this file or description.

@pitrou I've considering this problem before, we talked about it here: https://github.com/apache/arrow/issues/35776 , I forgot this previously

Personally I think this would be a bit tricky, what would you plan to be in 2.10? And some 2.10 files might be written with 2.6.0 now? 🤔

> Was there a change made to GetOptions recently? There seems to be a problem after the merge. Yes, the operations to db requires an options here.

Nice, I'll take a round tonight