cant use bind parameters in a database neutral way with textual queries, text()

the text() function which specifies textual queries should be able to take database-independent bind parameters:

text("select * from users where user_id=:user_id", engine=e).execute(user_id=10)

currently, the method of ansisql compilation only looks for bind parameters that are compiled from bindparam() objects.

also, its not consistent within the code if :bindparam or %(bindparam) is the generally recognized format for bind params in text queries.

Comments (1)