fix(sqlalchemy1.4) fix tests and a lot of warnings

fix(sqlalchemy1.4) fix tests and a lot of warnings #685