Very cool and very good timing. We just released better support to directly query S3[0] in Definite[1]. It's powered by duckdb.

0 - https://www.youtube.com/watch?v=yrrCQnfKEig

1 - https://www.definite.app/