From a Litestream user’s perspective:

Litestream continues to work as always, making continuous backups to S3.

Like always, I can restore from those backups to my local system.

But now I have the option of doing “virtual restores” where I can query a database backup directly on S3.