URLs in logs include trailing parentheses

[EmilRex]

Bug summary

URLs in logs that end with trailing parentheses (e.g. https://example.com)) include the parentheses in the actual link. This is particularly problematic when logging markdown which follows the [text](url) pattern. Ideally, trailing parentheses should not be included in any hyperlinks.

from prefect import flow, get_run_logger

@flow
def hello():
    logger = get_run_logger()
    logger.info("Hello, https://example.com")
    logger.info("Hello, https://example.com(")
    logger.info("Hello, https://example.com)")
    logger.info("Hello, [Example](https://example.com)")

if __name__ == "__main__":
    hello()

Version info (prefect version output)

Version:             2.20.4
API version:         0.8.4
Python version:      3.12.5
Git commit:          3b951c35
Built:               Wed, Aug 28, 2024 9:09 PM
OS/Arch:             darwin/arm64
Profile:             local
Server type:         server

Additional context

URL resolution in logs seems to have been added in this PR and the relevant regex lives here.