Streaming and updating in same transaction

[jasonish]

I'm migrating a Rusqlite workflow when I'm doing some data transformation on a very large table. In a transaction, I use a prepared statement, loop over the results in a stream fashion and do an update for each row.

With SQLx and using a futures stream this does not seem possible. I suppose one option is to bulk get a set of records, and do my updates. Essentially paginating the job, but is there no one due to updates on the same tx streaming the results?

Thanks.