Unfortunately, value1 gets clobbered by value2 because they both bind to value. Is there a general purpose solution to this? My real query is much more complex and dynamically constructed than this and can't be simplified by any tricks. What I want is unique parameter names that never clobber each other.

gistfile1.txt

db.session.query(MyTable).filter(
	db.or_(
		db.text("(my_table.json_field ->> key)::text = :value").bindparams(value=value1),
		db.text("(my_table.json_field ->> key)::text = :value").bindparams(value=value2),
	)
)