What makes you think the LLM won’t just handle that on its own, or ask the person doing the “development”?

Because there's no one correct answer and every decision involves engineering tradeoffs.

Who do you think the will be choosing whether the database uses a pessimistic or optimistic concurrency strategy? The CEO?