There are two ways of doing this that I know of:
1. FUSE filesystems. This means sending really slow queries to S3, and so you're much better off using compression to get better performance.
2. Syncing to filesystem with AWS DataSync. This would work, yes, but it's a S3 specific feature and not all blob storage systems have it.