How to write a sql query with parameters correctly?

Question

MySQL

date = '31/01/2015'
date_format = '%%d/%%m/%%Y'

Request:

rows = db.session.execute("SELECT * FROM weather WHERE DATE_FORMAT(putdate, %s) = %s", (date_format, date))

Gives an error message:

AttributeError: 'tuple' object has no attribute 'keys'

Answer 1

I tried myself

date = '31/01/2015'
date_format = '%d/%m/%Y'
g.cur.execute("""SELECT * FROM `per` WHERE DATE_FORMAT(`date_sf`, %s) = %s""",
                    (date_format, date))
rows = g.cur.fetchall()
print(rows)

That's how it works.
Well, even in relation to alchemy.
This is how it works:

date = '01/01/2015'                                                           
date_format = '%d/%m/%Y'                                                      
sql = """SELECT * FROM `users` WHERE DATE_FORMAT(`date`, '%s') = '%s' """ % (date_format, date)                                                       
rows = db.session.execute(sql)

And there is another way.
IMHO, the most correct:

from sqlalchemy import text
rows = db.session.execute(text("SELECT * FROM `users` WHERE  DATE_FORMAT(`date`, :df) = :date "), 
{"df": '%d/%m/%Y', "date": '01/01/2015'})