dbt container fails when using Python 3.13

[njuguna-n]

Describe the bug The latest version of dbt core (1.8.7) doesn't support the latest version of Python (3.13).

To Reproduce

1. Checkout the latest code from the main branch and run the docker compose command to run the required containers

Expected behavior The dbt container builds and runs without issues

Logs

2024-10-14 18:11:07 Traceback (most recent call last):
2024-10-14 18:11:07   File "/dbt/dbt-run.py", line 1, in <module>
2024-10-14 18:11:07     import psycopg2
2024-10-14 18:11:07   File "/usr/local/lib/python3.13/site-packages/psycopg2/__init__.py", line 51, in <module>
2024-10-14 18:11:07     from psycopg2._psycopg import (                     # noqa
2024-10-14 18:11:07     ...<10 lines>...
2024-10-14 18:11:07     )
2024-10-14 18:11:07 ImportError: /usr/local/lib/python3.13/site-packages/psycopg2/_psycopg.cpython-313-aarch64-linux-gnu.so: undefined symbol: _PyInterpreterState_Get

[medic-ci]

:tada: This issue has been resolved in version 1.1.3 :tada:

The release is available on GitHub release

Your semantic-release bot :package::rocket: