As presented in #789 , the upserts in current avram are more of "find_or_create", instead of utilizing upsert from postgres: https://www.postgresql.org/docs/9.5/sql-insert.html (INSERT INTO ... ON CONFLICT UPDATE)
This can be confusing to newcomers expecting upsert to be a single UPSERT query.