sripathikrishnan / jinjasql

Template Language for SQL with Automatic Bind Parameter Extraction
MIT License
807 stars 88 forks source link

Change '#' to '_' so sqlalchemy stops complaining #42

Open elpablete opened 2 years ago

elpablete commented 2 years ago

When using sqlachemy, bind parameters named with a '#' raise errors. Apparently this is due to sqlalchemy using '#' as a separator. Instead of expecting a bind parameter named 'bind#0_{n}', it looks for a bind parameter named ONLY 'bind'

"""sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter 'bind'"""