[CT-2846] Update dependency pins: click<9 + sqlparse<0.5

[jtcohen6]

Unpin click now that a new version has been released that should fix the typing issues:

• [CT-2804] Exclude click==8.1.4 from dependencies #8048
• Typing changes in 8.1.4 cause failure of mypy check pallets/click#2558 (comment)

---

We removed the sqlparse pin in #7993 — but we should still have an upper bound since it's major-0 software. Previously we had the upper bound pinned to <0.5.

---

We should backport to 1.6.latest (for inclusion in v1.6.0rc2/final) + 1.5.latest (for inclusion in v1.5.4)

[jtcohen6]

Looks like there are still some issues with mypy + click==8.1.6: #8146 (comment)

[emmyoop]

I don't know why these are combined. sqlparse can get an upper bound without any issues so I split it out to #8236.

[emmyoop]

opening up the pin for click does still have some mypy failures. specifically these just 3 in #8232. Question is if we want to ignore them or just not upgrade yet.

core/dbt/cli/params.py:392: error: Argument 2 to "option" has incompatible type "**Dict[str, Union[Type[Tuple[Any, ...]], bool, Type[MultiOption], str, None]]"; expected "Optional[Type[Option]]"  [arg-type]
core/dbt/cli/params.py:393: error: Argument 2 to "option" has incompatible type "**Dict[str, Union[Type[Tuple[Any, ...]], bool, Type[MultiOption], str, None]]"; expected "Optional[Type[Option]]"  [arg-type]
core/dbt/cli/params.py:394: error: Argument 3 to "option" has incompatible type "**Dict[str, Union[Type[Tuple[Any, ...]], bool, Type[MultiOption], str, None]]"; expected "Optional[Type[Option]]"  [arg-type]