I think that this is really the duality of LLMs. I can ask it to explain different database transaction models and it would perfectly explain to me how it works, which one to pick, and how to apply it.
But generated code by a LLM will likely also have bugs that could be fixed with transactions.