We are currently solving the following issue within our repository. Here is the issue text:
--- BEGIN ISSUE ---
[CT-3190] Pinning detective work
### Housekeeping

- [X] I am a maintainer of dbt-core

### Short description

We recently pinned `types-requests<2.31.0` because it had a dependency conflict with `urllib3` which we have pinned to `~=1.0` because of another conflict with `requests` requiring `openssl`.

This ticket is to look into if those pins are still required and clean them up if not.  

### Acceptance criteria

We have confirmed that the pins are
- required to continue to work
_or_
- not required and we have re-pinned appropriately

### Impact to Other Teams

adapters - based on the notes it seems like `urllib3` is pinned for the snowflake adapter as well so we will want to ensure changing the dependencies does not adversely affect them

### Will backports be required?

no

### Context

_No response_

--- END ISSUE ---

Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
--- BEGIN FILES ---
Path: `core/setup.py`
Content:
```
1 #!/usr/bin/env python
2 import os
3 import sys
4 
5 if sys.version_info < (3, 8):
6     print("Error: dbt does not support this version of Python.")
7     print("Please upgrade to Python 3.8 or higher.")
8     sys.exit(1)
9 
10 
11 from setuptools import setup
12 
13 try:
14     from setuptools import find_namespace_packages
15 except ImportError:
16     # the user has a downlevel version of setuptools.
17     print("Error: dbt requires setuptools v40.1.0 or higher.")
18     print('Please upgrade setuptools with "pip install --upgrade setuptools" ' "and try again")
19     sys.exit(1)
20 
21 
22 this_directory = os.path.abspath(os.path.dirname(__file__))
23 with open(os.path.join(this_directory, "README.md")) as f:
24     long_description = f.read()
25 
26 
27 package_name = "dbt-core"
28 package_version = "1.8.0a1"
29 description = """With dbt, data analysts and engineers can build analytics \
30 the way engineers build applications."""
31 
32 
33 setup(
34     name=package_name,
35     version=package_version,
36     description=description,
37     long_description=long_description,
38     long_description_content_type="text/markdown",
39     author="dbt Labs",
40     author_email="info@dbtlabs.com",
41     url="https://github.com/dbt-labs/dbt-core",
42     packages=find_namespace_packages(include=["dbt", "dbt.*"]),
43     include_package_data=True,
44     test_suite="test",
45     entry_points={
46         "console_scripts": ["dbt = dbt.cli.main:cli"],
47     },
48     install_requires=[
49         # ----
50         # dbt-core uses these packages deeply, throughout the codebase, and there have been breaking changes in past patch releases (even though these are major-version-one).
51         # Pin to the patch or minor version, and bump in each new minor version of dbt-core.
52         "agate~=1.7.0",
53         "Jinja2~=3.1.2",
54         "mashumaro[msgpack]~=3.9",
55         # ----
56         # Legacy: This package has not been updated since 2019, and it is unused in dbt's logging system (since v1.0)
57         # The dependency here will be removed along with the removal of 'legacy logging', in a future release of dbt-core
58         "logbook>=1.5,<1.6",
59         # ----
60         # dbt-core uses these packages in standard ways. Pin to the major version, and check compatibility
61         # with major versions in each new minor version of dbt-core.
62         "click>=8.0.2,<9",
63         "networkx>=2.3,<4",
64         # ----
65         # These packages are major-version-0. Keep upper bounds on upcoming minor versions (which could have breaking changes)
66         # and check compatibility / bump in each new minor version of dbt-core.
67         "pathspec>=0.9,<0.12",
68         "sqlparse>=0.2.3,<0.5",
69         # ----
70         # These are major-version-0 packages also maintained by dbt-labs. Accept patches.
71         "dbt-extractor~=0.5.0",
72         "minimal-snowplow-tracker~=0.0.2",
73         "dbt-semantic-interfaces~=0.5.0a2",
74         "dbt-common~=0.1.0",
75         "dbt-adapters~=0.1.0a2",
76         # ----
77         # Expect compatibility with all new versions of these packages, so lower bounds only.
78         "packaging>20.9",
79         "protobuf>=4.0.0",
80         "pytz>=2015.7",
81         "pyyaml>=6.0",
82         "daff>=1.3.46",
83         "typing-extensions>=4.4",
84         # ----
85     ],
86     zip_safe=False,
87     classifiers=[
88         "Development Status :: 5 - Production/Stable",
89         "License :: OSI Approved :: Apache Software License",
90         "Operating System :: Microsoft :: Windows",
91         "Operating System :: MacOS :: MacOS X",
92         "Operating System :: POSIX :: Linux",
93         "Programming Language :: Python :: 3.8",
94         "Programming Language :: Python :: 3.9",
95         "Programming Language :: Python :: 3.10",
96         "Programming Language :: Python :: 3.11",
97     ],
98     python_requires=">=3.8",
99 )
100
```
--- END FILES ---

Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.

Here is an example:

```diff
diff --git a/examples/server_async.py b/examples/server_async.py
--- a/examples/server_async.py
+++ b/examples/server_async.py
@@ -313,4 +313,4 @@
 
 
 if __name__ == "__main__":
-    asyncio.run(run_async_server("."), debug=True)
+    asyncio.run(run_async_server(), debug=True)
diff --git a/examples/server_sync.py b/examples/server_sync.py
--- a/examples/server_sync.py
+++ b/examples/server_sync.py
@@ -313,5 +313,5 @@
 
 
 if __name__ == "__main__":
-    server = run_sync_server(".")
+    server = run_sync_server()
     server.shutdown()

```

diff --git a/core/setup.py b/core/setup.py
--- a/core/setup.py
+++ b/core/setup.py
@@ -61,6 +61,7 @@
         # with major versions in each new minor version of dbt-core.
         "click>=8.0.2,<9",
         "networkx>=2.3,<4",
+        "requests<3.0.0",  # should match dbt-common
         # ----
         # These packages are major-version-0. Keep upper bounds on upcoming minor versions (which could have breaking changes)
         # and check compatibility / bump in each new minor version of dbt-core.

{"golden_diff": "diff --git a/core/setup.py b/core/setup.py\n--- a/core/setup.py\n+++ b/core/setup.py\n@@ -61,6 +61,7 @@\n         # with major versions in each new minor version of dbt-core.\n         \"click>=8.0.2,<9\",\n         \"networkx>=2.3,<4\",\n+        \"requests<3.0.0\",  # should match dbt-common\n         # ----\n         # These packages are major-version-0. Keep upper bounds on upcoming minor versions (which could have breaking changes)\n         # and check compatibility / bump in each new minor version of dbt-core.\n", "issue": "[CT-3190] Pinning detective work\n### Housekeeping\n\n- [X] I am a maintainer of dbt-core\n\n### Short description\n\nWe recently pinned `types-requests<2.31.0` because it had a dependency conflict with `urllib3` which we have pinned to `~=1.0` because of another conflict with `requests` requiring `openssl`.\r\n\r\nThis ticket is to look into if those pins are still required and clean them up if not.  \n\n### Acceptance criteria\n\nWe have confirmed that the pins are\r\n- required to continue to work\r\n_or_\r\n- not required and we have re-pinned appropriately\n\n### Impact to Other Teams\n\nadapters - based on the notes it seems like `urllib3` is pinned for the snowflake adapter as well so we will want to ensure changing the dependencies does not adversely affect them\n\n### Will backports be required?\n\nno\n\n### Context\n\n_No response_\n", "before_files": [{"content": "#!/usr/bin/env python\nimport os\nimport sys\n\nif sys.version_info < (3, 8):\n    print(\"Error: dbt does not support this version of Python.\")\n    print(\"Please upgrade to Python 3.8 or higher.\")\n    sys.exit(1)\n\n\nfrom setuptools import setup\n\ntry:\n    from setuptools import find_namespace_packages\nexcept ImportError:\n    # the user has a downlevel version of setuptools.\n    print(\"Error: dbt requires setuptools v40.1.0 or higher.\")\n    print('Please upgrade setuptools with \"pip install --upgrade setuptools\" ' \"and try again\")\n    sys.exit(1)\n\n\nthis_directory = os.path.abspath(os.path.dirname(__file__))\nwith open(os.path.join(this_directory, \"README.md\")) as f:\n    long_description = f.read()\n\n\npackage_name = \"dbt-core\"\npackage_version = \"1.8.0a1\"\ndescription = \"\"\"With dbt, data analysts and engineers can build analytics \\\nthe way engineers build applications.\"\"\"\n\n\nsetup(\n    name=package_name,\n    version=package_version,\n    description=description,\n    long_description=long_description,\n    long_description_content_type=\"text/markdown\",\n    author=\"dbt Labs\",\n    author_email=\"info@dbtlabs.com\",\n    url=\"https://github.com/dbt-labs/dbt-core\",\n    packages=find_namespace_packages(include=[\"dbt\", \"dbt.*\"]),\n    include_package_data=True,\n    test_suite=\"test\",\n    entry_points={\n        \"console_scripts\": [\"dbt = dbt.cli.main:cli\"],\n    },\n    install_requires=[\n        # ----\n        # dbt-core uses these packages deeply, throughout the codebase, and there have been breaking changes in past patch releases (even though these are major-version-one).\n        # Pin to the patch or minor version, and bump in each new minor version of dbt-core.\n        \"agate~=1.7.0\",\n        \"Jinja2~=3.1.2\",\n        \"mashumaro[msgpack]~=3.9\",\n        # ----\n        # Legacy: This package has not been updated since 2019, and it is unused in dbt's logging system (since v1.0)\n        # The dependency here will be removed along with the removal of 'legacy logging', in a future release of dbt-core\n        \"logbook>=1.5,<1.6\",\n        # ----\n        # dbt-core uses these packages in standard ways. Pin to the major version, and check compatibility\n        # with major versions in each new minor version of dbt-core.\n        \"click>=8.0.2,<9\",\n        \"networkx>=2.3,<4\",\n        # ----\n        # These packages are major-version-0. Keep upper bounds on upcoming minor versions (which could have breaking changes)\n        # and check compatibility / bump in each new minor version of dbt-core.\n        \"pathspec>=0.9,<0.12\",\n        \"sqlparse>=0.2.3,<0.5\",\n        # ----\n        # These are major-version-0 packages also maintained by dbt-labs. Accept patches.\n        \"dbt-extractor~=0.5.0\",\n        \"minimal-snowplow-tracker~=0.0.2\",\n        \"dbt-semantic-interfaces~=0.5.0a2\",\n        \"dbt-common~=0.1.0\",\n        \"dbt-adapters~=0.1.0a2\",\n        # ----\n        # Expect compatibility with all new versions of these packages, so lower bounds only.\n        \"packaging>20.9\",\n        \"protobuf>=4.0.0\",\n        \"pytz>=2015.7\",\n        \"pyyaml>=6.0\",\n        \"daff>=1.3.46\",\n        \"typing-extensions>=4.4\",\n        # ----\n    ],\n    zip_safe=False,\n    classifiers=[\n        \"Development Status :: 5 - Production/Stable\",\n        \"License :: OSI Approved :: Apache Software License\",\n        \"Operating System :: Microsoft :: Windows\",\n        \"Operating System :: MacOS :: MacOS X\",\n        \"Operating System :: POSIX :: Linux\",\n        \"Programming Language :: Python :: 3.8\",\n        \"Programming Language :: Python :: 3.9\",\n        \"Programming Language :: Python :: 3.10\",\n        \"Programming Language :: Python :: 3.11\",\n    ],\n    python_requires=\">=3.8\",\n)\n", "path": "core/setup.py"}], "after_files": [{"content": "#!/usr/bin/env python\nimport os\nimport sys\n\nif sys.version_info < (3, 8):\n    print(\"Error: dbt does not support this version of Python.\")\n    print(\"Please upgrade to Python 3.8 or higher.\")\n    sys.exit(1)\n\n\nfrom setuptools import setup\n\ntry:\n    from setuptools import find_namespace_packages\nexcept ImportError:\n    # the user has a downlevel version of setuptools.\n    print(\"Error: dbt requires setuptools v40.1.0 or higher.\")\n    print('Please upgrade setuptools with \"pip install --upgrade setuptools\" ' \"and try again\")\n    sys.exit(1)\n\n\nthis_directory = os.path.abspath(os.path.dirname(__file__))\nwith open(os.path.join(this_directory, \"README.md\")) as f:\n    long_description = f.read()\n\n\npackage_name = \"dbt-core\"\npackage_version = \"1.8.0a1\"\ndescription = \"\"\"With dbt, data analysts and engineers can build analytics \\\nthe way engineers build applications.\"\"\"\n\n\nsetup(\n    name=package_name,\n    version=package_version,\n    description=description,\n    long_description=long_description,\n    long_description_content_type=\"text/markdown\",\n    author=\"dbt Labs\",\n    author_email=\"info@dbtlabs.com\",\n    url=\"https://github.com/dbt-labs/dbt-core\",\n    packages=find_namespace_packages(include=[\"dbt\", \"dbt.*\"]),\n    include_package_data=True,\n    test_suite=\"test\",\n    entry_points={\n        \"console_scripts\": [\"dbt = dbt.cli.main:cli\"],\n    },\n    install_requires=[\n        # ----\n        # dbt-core uses these packages deeply, throughout the codebase, and there have been breaking changes in past patch releases (even though these are major-version-one).\n        # Pin to the patch or minor version, and bump in each new minor version of dbt-core.\n        \"agate~=1.7.0\",\n        \"Jinja2~=3.1.2\",\n        \"mashumaro[msgpack]~=3.9\",\n        # ----\n        # Legacy: This package has not been updated since 2019, and it is unused in dbt's logging system (since v1.0)\n        # The dependency here will be removed along with the removal of 'legacy logging', in a future release of dbt-core\n        \"logbook>=1.5,<1.6\",\n        # ----\n        # dbt-core uses these packages in standard ways. Pin to the major version, and check compatibility\n        # with major versions in each new minor version of dbt-core.\n        \"click>=8.0.2,<9\",\n        \"networkx>=2.3,<4\",\n        \"requests<3.0.0\",  # should match dbt-common\n        # ----\n        # These packages are major-version-0. Keep upper bounds on upcoming minor versions (which could have breaking changes)\n        # and check compatibility / bump in each new minor version of dbt-core.\n        \"pathspec>=0.9,<0.12\",\n        \"sqlparse>=0.2.3,<0.5\",\n        # ----\n        # These are major-version-0 packages also maintained by dbt-labs. Accept patches.\n        \"dbt-extractor~=0.5.0\",\n        \"minimal-snowplow-tracker~=0.0.2\",\n        \"dbt-semantic-interfaces~=0.5.0a2\",\n        \"dbt-common~=0.1.0\",\n        \"dbt-adapters~=0.1.0a2\",\n        # ----\n        # Expect compatibility with all new versions of these packages, so lower bounds only.\n        \"packaging>20.9\",\n        \"protobuf>=4.0.0\",\n        \"pytz>=2015.7\",\n        \"pyyaml>=6.0\",\n        \"daff>=1.3.46\",\n        \"typing-extensions>=4.4\",\n        # ----\n    ],\n    zip_safe=False,\n    classifiers=[\n        \"Development Status :: 5 - Production/Stable\",\n        \"License :: OSI Approved :: Apache Software License\",\n        \"Operating System :: Microsoft :: Windows\",\n        \"Operating System :: MacOS :: MacOS X\",\n        \"Operating System :: POSIX :: Linux\",\n        \"Programming Language :: Python :: 3.8\",\n        \"Programming Language :: Python :: 3.9\",\n        \"Programming Language :: Python :: 3.10\",\n        \"Programming Language :: Python :: 3.11\",\n    ],\n    python_requires=\">=3.8\",\n)\n", "path": "core/setup.py"}]}