# If you're using SQLAlchemy:
# Use "%%" instead of "%" in your queries, because
# a single "%" is used in Python string formatting.

# Alternatively escape the SQL properly with sqlalchemy.text(...):
engine.execute(sqlalchemy.text(sql_query))

Source-https://iqcode.com/


You have to give %% to use it as % because % in python is use as string formatting so when you write single % its assume that you are going to replace some value with this.

So when you want to place single % in string with query allways place double %.