> why use a SQLite abstraction library when I can use LLMs to interact directly with the C source code?
Because of the accumulated knowledge in these abstraction layers and because of the abstraction itself resulting in readable and maintainable code.
Yes you can move the abstraction one level up, but you don't control it if you nor the LLM meet the level of accumulated knowledge that is embedded in this abstraction. Let alone future contributors to your codebase.
Of course it is all depending on context and there is no one-fits-all strategy here.
Because of the accumulated knowledge in these abstraction layers and because of the abstraction itself resulting in readable and maintainable code.
Yes you can move the abstraction one level up, but you don't control it if you nor the LLM meet the level of accumulated knowledge that is embedded in this abstraction. Let alone future contributors to your codebase.
Of course it is all depending on context and there is no one-fits-all strategy here.