PEP 0249¶

This PEP is overall internal DBAPI core for Python

paramstyle String constant stating the type of parameter marker formatting expected by the interface. Possible values are [2]: paramstyle Meaning qmark Question mark style, e.g. ...WHERE name=? numeric Numeric, positional style, e.g. ...WHERE name=:1 named Named style, e.g. ...WHERE name=:name format ANSI C printf format codes, e.g. ...WHERE name=%s pyformat Python extended format codes, e.g. ...WHERE name=%(name)s

https://peps.python.org/pep-0249/#constructors