Upgrade to SQLAlchemy v2.0

[achimnol]

SQLAlchemy v1.4 is a bridge release to migrate v2.0 with introduction of asyncio-native ORM.
It's been almost one year since the first release of v2.0 and I think it should have less hassles of the early versions.
Our codebase already follows the most of best practices for migration to v2.0.

Let's migrate to v2.0 in favor of better type annotation support.

Tasks

Beta Give feedback

1. Apply __allow_unmapped__ = True to explicitly typed ORM models
2. Replace all select([]) patterns to select() patterns
3. In query results, replace codes that get the field value by key-name with codes that get the field value by an attribute. (from row["name"] to row.name)

[achimnol]

Let's revisit this issue.

[Yaminyam]

I will also join in on this issue.