there is a kitchen-sink "wof" command line tool that I've been working on / which deserves its own long and twisty blog post soon / but for now I'll just say that / it has learned how to produce geoparquet databases from one or more who's on first repositories – https://github.com/whosonfirst/wof-cli?tab=readme-ov-file#example-geoparquet
GitHub - whosonfirst/wof-cli: Command-line tool for common Who's On First operations.

Command-line tool for common Who's On First operations. - whosonfirst/wof-cli

GitHub