db-gen script not running correctly with Python 3.11 due to sqlacodegen

[indraneel]

Describe the bug

When running db-gen.sh with Python 3.11, seeing this error:

 File "/Users/indraneel/opt/anaconda3/envs/mdfeed/lib/python3.11/site-packages/sqlacodegen/codegen.py", line 9, in <module>
    from inspect import ArgSpec

Steps/Code to Reproduce

1. Follow setup steps in Readme
2. Use Python 3.11
3. Try to run db-gen.sh

Expected Results

db-gen.sh should run

Actual Results

 File "/Users/indraneel/opt/anaconda3/envs/mdfeed/lib/python3.11/site-packages/sqlacodegen/codegen.py", line 9, in <module>
    from inspect import ArgSpec

Screenshots

No response

Files used

No response

Additional notes

From the sqlacodegen repo, it seems like the issue is fixed in the v3 release candidate agronholm/sqlacodegen#239 (comment)

So the paired fix to this will be adding that version to requirements.txt

[welcome]

Thanks for opening your first issue in this project! If you haven't already, you can join our slack and join the #mobility-database channel to meet our awesome community. Come say hi 👋!

Welcome to the community and thank you for your engagement in open source! 🎉