Feature: support batch with "select for update"

## Why you need it?
Is your feature request related to a problem? Please describe in details
support like this:
....for update
....for update

## How it could be?
A clear and concise description of what you want to happen. You can explain more about input of the feature, and output of it.

## Other related information
Add any other context or screenshots about the feature request here.

The issue names no files, tests, or entry points. Start by locating the batch operation and existing select-for-update handling, then determine the expected API and database behavior; done means batch requests support the requested locking semantics with regression coverage.

Written by the indexing model from the issue text.