SQLAlchemy: proper way to specify connection URL in python

Using SQLAlchemy (version 2.0.4)to connect to a remote MySQL server from python via the pymysql driver.

If I declare my connection URL in the "simple" way, it works:

import sqlalchemy as db
engine = db.create_engine("mysql+pymysql://dbuser:verysecret@myhost.com:9001/mydb")

but I'd prefer this other version I've found in a tutorial:

import sqlalchemy as db
connect_url = db.engine.url.URL(
    "mysql+pymysql",
    username="dbuser",
    password="verysecret",
    host="myhost.com",
    port="9001",
    database="mydb",
)

engine = db.create_engine(connect_url)

but this fails on the connect_url line as follows:

Traceback (most recent call last):
  File "/Users/bob/Documents/work/code/mysqltest/mysqltest/sqlalch.py", line 3, in <module>
    connect_url = db.engine.url.URL(
TypeError: URL.__new__() missing 1 required positional argument: 'query'

EDIT: thanks to @snakecharmer's reply below I then tried to add a valid query parameter as follows:

import sqlalchemy as db

connect_url = db.engine.url.URL(
    "mysql+pymysql",
    username="root",
    password="ghj12WQ_AA1997",
    host="isagog.com",
    port=9001,
    database="athena",
    query=dict(charset="utf8mb4"),
)

engine = db.create_engine(connect_url)

And this does works well. But still not sure why I get an error if the query parameter is not provided.

If you don't need to pass any query parameters, pass an empty string or dict for query:

>>> url = sa.engine.URL('mysql+pymysql', 'root', 'root', 'localhost', 3306, 'test', {})
>>> url
mysql+pymysql://root:***@localhost:3306/test

If you need to pass query arguments, pass them as a dictionary:

>>> import sqlalchemy as sa
>>>
>>> url = sa.engine.URL('mysql+pymysql', 'root', 'root', 'localhost', 3306, 'test', {'charset': 'utf8mb4'})
>>> url
mysql+pymysql://root:***@localhost:3306/test?charset=utf8mb4