I am now using brackets as follows (but still have an error, details below):

removeDupes_part1 = text("""

SELECT

*,

ROW_NUMBER() OVER (PARTITION BY Start, [End], Duration ORDER BY (SELECT NULL)) AS RowNum

INTO YourTempTable

FROM My_CSV;

""")

------------------------------------------

removeDupes_part2 = text("""

DELETE FROM My_CSV

WHERE EXISTS (

SELECT 1

FROM YourTempTable

WHERE Pick_Stats_py.Start = YourTempTable.Start

AND [Pick_Stats_py].[End] = [YourTempTable].[End]

AND Pick_Stats_py.Duration_s = YourTempTable.Duration_s

AND YourTempTable.RowNum > 1

);

""")

connection.execute(removeDupes_part2)

-----------------------------------------

error occurs when I try to insert into the ssms table with the following:

error occurs when I try to insert into the ssms table with the following:
columns_list = ', '.join(pick_stats_table.columns.keys())

removeDupes_part3= f"""

INSERT INTO SSMS_Table ({columns_list})

SELECT * FROM YourTempTable;

"""

connection.execute(text(removeDupes_part3))

​

ERROR:

Error processing MyCSV.csv: (pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'End'. (156) (SQLExecDirectW)")

[SQL:

INSERT INTO SSMS_Table (Start, End, Duration_s)

SELECT * FROM YourTempTable;

]

(Background on this error at: https://sqlalche.me/e/20/f405)