ruby-dbi was one of the first database abstraction libraries.
It offered a database independent API, so the same code could work on more than one database.
However, only the APIs were database independent. The programmer was still responsible for making sure the SQL being used was database independent, which could be difficult.