["Request"] Specify `AT_MOST_ONCE` and `EXACTLY_ONCE` in applicable lambdas

[nomisRev]

In most HOF in Arrow we can specify AT_MOST_ONCE and EXACTLY_ONCE. Currently, we're not doing so, and this prevents certain code to be written that would otherwise be valid.