It has Parquet/JSON/httpfs support, but requires a Workers Pro plan subscription due to the Workers size limits (3MB Free / 10MB Pro).
You can query data from R2 directly from a Worker! The max memory is 128MB, so this limits the amount of data you can query though.