[api] migrate to sqlalchemy 2.x

[righel]

see: https://docs.sqlalchemy.org/en/20/changelog/migration_20.html