> This looks like a (very thin) wrapper of the psycopg2 library, which is a wrapper around the python DB API

psycopg2 is an implementation of DBAPI2 (with extensions). As the name denotes, DBAPI is an API which database libraries ought implement, it's not a library.