Amin Alaee

I just tested that fix but that doesn't solve the issue.

yes, that fails on other drivers too, I've tried sqlite.

I think this is the behaviour of `bindparams` in SQLAlchemy, which is correct. Databases uses bindparams to set query parameters. An example from SQLAlchemy: ```python stmt = text("SELECT id, name...

I think it would require more information like example of how you're making queries, code samples, etc to help with it.

@yinshurman The fix shouldn't be too hard. I'll do a simple draft.

I'll take a look into it.

I'll try to take a look into this, if you find a solution feel free to create a PR for it though.

This isn't really related to FastAPI. So maybe you can rename the title. I could reproduce this that if a query is run before a transaction, the transaction isn't rolled...

@goteguru I think this is related to the parallel transactions #328 . Here https://github.com/encode/databases/blob/master/databases/core.py#L206 If we avoid creating new connection and use existing connection, this issue will be fixed. But...

Let's wait for the base branch to be dealt with so we can review this. But I like the windows compatibility approach anyway. Maybe we can also add it to...