But a more specific library would be better able to cope with the unique features of a particular database. Why send commands via 'prompt' when a more specialised library will have functions to do that job?

I think there's definitely a place for libraries that add things like validation to models. But the more functionality you include, the more specific your library needs to be.