import datetime

import pyodbc

connection_string = (
    "DRIVER=ODBC Driver 17 for SQL Server;"
    "SERVER=192.168.0.199;"
    "UID=scott;PWD=tiger^5HHH;"
    "DATABASE=test;"
)
cnxn = pyodbc.connect(
    connection_string,
    autocommit=True,
)

print(pyodbc.version)  # 4.0.32
print(cnxn.getinfo(pyodbc.SQL_DBMS_NAME))  # Microsoft SQL Server
print(cnxn.getinfo(pyodbc.SQL_DBMS_VER))  # 15.00.4023

crsr = cnxn.cursor()

crsr.execute("CREATE TABLE ##tmp (id int primary key, dto datetimeoffset)")

my_tz = datetime.timezone(datetime.timedelta(hours=-7))
dto_value = datetime.datetime(2020, 1, 1, 0, 0, 0, tzinfo=my_tz)
print(dto_value)  # 2020-01-01 00:00:00-07:00

crsr.fast_executemany = True
crsr.executemany("INSERT INTO ##tmp (id, dto) VALUES (?, ?)", [(1, dto_value)])

print(
    crsr.execute(
        "SELECT id, CAST(dto AS nvarchar(max)) AS dto_str FROM ##tmp"
    ).fetchall()
)
# [(1, '2020-01-01 00:00:00.0000000 -07:00')]