[v5.1.0] Refactor the rest of the repositories to use sqlalchemy core 1.4

[v5.1.0] Refactor the rest of the repositories to use sqlalchemy core 1.4 #623