How to add a Python variable to an SQL query?

Question

Python

Can you tell me how to add a variable to a query?
The project is a chat bot using dialogflow. When a certain command is received, it is necessary to write the client data to the database. How to transfer the data received from the input line to the database on MS SQL server?
I googled a little and did this:

print('Введите сообщение...')
message = input()
action = None
while True:
    action = send_message(message)
    if action == 'me.order':
        connection = pypyodbc.connect('Driver={SQL Server};'
                                      'Server=' + mySQLServer + ';'
                                      'Database=' + myDataBase + ';')

        cursor = connection.cursor()

        mySQLQuerySelect = (""" 
                        SELECT [name], [pnumber], [date]
                        FROM [dbo].[Order]
                        """)

        cursor.execute(mySQLQuerySelect)

        table = cursor.fetchall()
        clientName = input()
        print('Хорошо, ' + clientName + '. А теперь введите номер своего мобильного телефона в формате +79*********:')
        clientPhone = input()
        mySQLQueryInsert = ("""
                            INSERT INTO [dbo].[Order] ([name], [pnumber])
                            VALUES (""" + clientName + """, """ + clientPhone + """)"""
                            )
        cursor.execute(mySQLQueryInsert)
        print('Спасибо, ваши данные успешно записаны! Ожидайте звонка от специалиста в течение текущего рабочего дня')
        connection.close()
        break

But in this case I get an error

Answer 1

I didn’t work with Mysql in python, but with SQLite I do it as follows:

NameP=itemsoft['name']
s = 'SELECT * FROM program WHERE (name LIKE "' + NameP + '%%")'
CurBLpro.execute(s)
records = CurBLpro.fetchall()

but this is getting data from the database, in fact, which prevents us from making a record according to the same logic.