ENG-6897: expose flush on CSVTuple and Bulk iinterface.

I think adding `drain()` here would match expectation, e.g. if I want to `flush()` periodically without closing just to make sure tuples are inserted.