Thank you very much for your attention. I'm afraid this may not be soon.
I'm an old man, retired, I've worked with mainframes since the late 1960s, it's been over 50 years. You could say that mainframes are the source of everything we have now. Just to give you an idea, in June 1970 IBM launched a new generation of equipment, /370, and among many new developments, there was, for example, the concept of Virtual Machine, which would only be used on microcomputers at the end of the last century .
What we call Schedulling Tools also appeared, they are used to automate production processes, with a reduction in execution time and an error rate of practically zero. However, there is a golden rule for this to happen: the system is only implemented when there is a certain number of people who have mastered the entire manual process, who can intervene in a failure in the automatic process for maximum damage reduction, as well as plenty documentation of the entire process.
Why am I saying this? You quoted the following: "https://codeigniter.com/user_guide/model...your-model does not solve this problem, it assumes the problem is already solved by a human already knowing which column is autoincrement and manually changing the source code accordingly before running it."
In other words, what the manual is saying, in the best scenario, is that it is assumed that a Data Modeling was done in which tables, fields, columns have a reason for being, etc., which suggests the existence of individuals with full knowledge of this part of what will become a set of steps, an application.
In this area of frameworks, PHP and everything related to microcomputers, I'm a beginner, an amateur, but I'm lucky to have a theoretical and practical basis that help me, a lot.
I have a private, local website, where I avoid being in an absolute state of idleness.
ATTENTION: all this does not mean that I am right and you are wrong and vice versa, only that we think differently.
And in relation to database-agnostic, I think the most appropriate metaphor is database-laic, which recognizes and allows the existence of different technologies, both in essence, philosophy and goals, in perfect harmony. But that, who knows, is for another time.
Thanks for your patience and understanding.
Hugs.
