>IMO, the best solution is to use a cursor as it scales better. If you want to add a value manually, you can simply append a record to the cursor and if necessary, add a flag to indicate that the new manually added value should be written to the backend.

Yes, exactly, as I described to Cetin.