Allow a 'RETURNING' alternative for update/insert/delete

[polo-asm]

Currently when doing update/insert/delete the result is generally the number of row impacted.
It could be very useful to implement a RETURNING alternative for theses methods to be able to SELECT theses rows at the same time.

[lex148]

This sounds interesting. I think I follow, but could you give me an example of what you are thinking.

something like this?

  let updated_cars = Car::all()
    .where(|c| c.price.gt(10_000))
    .set(|c| c.price, 0)
    .run_and_select(&conn).await?; 

not sure what the expected behavior would be for delete. there wouldn't be anything in the database. would you want back the deleted rows?

[polo-asm]

Exactly, the syntax of your example seems good.

For delete the RETURNING clause, take delete rows. Maybe the name should not be 'delete _and_select' in this case. Something with 'take' ?