update pydantic to version 2

chore:

• remove sqlalchemy and pydantic from pyproject.toml, because they are dependencies of sqlmodel
• update sqlmodel to newest version
• add unittest to gitlab pipeline

fix(sql, restapi):

• migrate to newest sqlalchemy and pydantic

changes(sql, utils, manual_pp, pika_server):

• add unittest for sql.view.topdown, issue and statistic view
• remove random footprint in sql.view.topdown queries => create typesafe sqlalchemy result wrappers for topdown project, user and jobname queries
• move manualpostproc view from sql.view.meta into manual_post_processing.py
• make utils.logger mypy aware
• make pika_server.py mypy aware