Issue regarding database (sqlalchemy, psycopg2)

[kotronis-te]

Does anyone in the community have an idea about the following, or encountered this before?
Issue described in detail in #1005. I updated sqlalchemy and alembic (psycopg2 is already in latest version), but still the same issue. I am using current latest version (v4.5.0b1) that includes the Prom metrics that we need for observability, but cannot get around this issue when we query data via the event stream.

Traceback (most recent call last):
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/uvicorn/protocols/http/httptools_impl.py", line 409, in run_asgi
    result = await app(  # type: ignore[func-returns-value]
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
    return await self.app(scope, receive, send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/applications.py", line 112, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
    raise exc
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
    await self.app(scope, receive, _send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/asgi_logger/middleware.py", line 61, in __call__
    raise exc
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/asgi_logger/middleware.py", line 58, in __call__
    await self.app(scope, receive, inner_send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/irrd/server/http/app.py", line 135, in __call__
    await self.app(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/middleware/sessions.py", line 85, in __call__
    await self.app(scope, receive, send_wrapper)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette_wtf/csrf.py", line 143, in __call__
    await self.app(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/imia/authentication.py", line 231, in __call__
    await self._app(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
    await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
    raise exc
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
    await app(scope, receive, sender)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/routing.py", line 714, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/routing.py", line 734, in app
    await route.handle(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
    await self.app(scope, receive, send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/endpoints.py", line 41, in dispatch
    await response(self.scope, self.receive, self.send)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/responses.py", line 262, in __call__
    with collapse_excgroups():
  File "/usr/lib/python3.12/contextlib.py", line 158, in __exit__
    self.gen.throw(value)
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/_utils.py", line 82, in collapse_excgroups
    raise exc
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/responses.py", line 266, in wrap
    await func()
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/starlette/responses.py", line 246, in stream_response
    async for chunk in self.body_iterator:
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/irrd/server/http/event_stream.py", line 74, in stream_response
    async for row in self.generate_rows():
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/irrd/server/http/event_stream.py", line 86, in generate_rows
    postgres_copy.copy_to(
  File "/home/irrd/irrd-venv/lib/python3.12/site-packages/irrd/vendor/postgres_copy/__init__.py", line 62, in copy_to
    cursor.copy_expert(copy, dest)
psycopg2.errors.UndefinedColumn: column "__" does not exist
LINE 3: WHERE rpsl_objects.rpki_status IN (__[POSTCOMPILE_rpki_statu...