dumb question: can this be used for versioned tables then ? what to see the state of a table 1 hour ago ?

Author here. You can query the state of a table from an hour ago with Litestream VFS. It won't give you versioned tables in the sense that every time you update a row that it writes a new version in a table somewhere though.