Need help on how to include single quotes on data of variable string

[hani_hms]

I am not unable to figure out why Python cannot include single quotes on to the value of the variable string. I am trying to add single quote on the beginning and at the end of the of the data variable current_partnum on the line no. 14. This variable's value will then be use to make mysql query2 using this line of code:

[inline]
query2 = "SELECT PartNum, WareHouseCode, BinNum, TranQty FROM trans WHERE PartNum = {}".format(current_partnum)
[/inline]

So my final query should be:

SELECT PartNum, WareHouseCode, BinNum, TranQty FROM trans WHERE PartNum = '10670APRCONX22XXXX'

But instead I am getting this output:

Output:
'ELECT PartNum, WareHouseCode, BinNum, TranQty FROM trans WHERE PartNum = '10670APRCONX22XXXX

Below is my code and its output

for (var_partNum) in record:

    #Start of Debug
    print("\nHMS: Debug")
    print(var_partNum[0])
    print(var_partNum)
    #End of Debug
    current_partnum = ' '.join(var_partNum)

    print("\nWorking on record "+ str(i) + " From " + str(total_records)) #Display active record number to track the progress
    print(current_partnum)
    #current_partnum = "!!{}!!".format(current_partnum)
    print(current_partnum)
    current_partnum = "'" + current_partnum + "'"   
    print(type(current_partnum))
    print(current_partnum)
    query2 = "SELECT PartNum, WareHouseCode, BinNum, TranQty FROM trans WHERE PartNum = {}".format(current_partnum)
    print(query2) 
    cursor.execute(query2,(current_partnum)) #To get the details for each FG partnum and then process the query result to save into the excel file
    record2 = cursor.fetchall()
    found_record = cursor.rowcount
     #Start of Debug
    print("\nfound_record = " + str(found_record))
    #End of Debug

Output:
Found total records: 846

HMS: Debug
10670APRCONX22XXXX
('10670APRCONX22XXXX\r',)

Working on record 1 From 846
10670APRCONX22XXXX
10670APRCONX22XXXX
<class 'str'>
'10670APRCONX22XXXX
'ELECT PartNum, WareHouseCode, BinNum, TranQty FROM trans WHERE PartNum = '10670APRCONX22XXXX

I don't understand why the SELECT statement the character S is replaced with single quotes.