cloudflare / cloudflare/sqlalchemy-clickhouse
Support sqlalchemy style parameterized queries
Open
- Dominant language
- Python
- Stars
- 325
- Forks
- 101
- PR merge metrics
- No merged PRs in 30d
Description
I would like to be able to use the [sqlalchemy style parameterized queries](https://docs.sqlalchemy.org/en/latest/core/sqlelement.html#sqlalchemy.sql.expression.text) within this dialect.
```python
from sqlalchemy import text
result = connection.execute(text("SELECT * FROM users WHERE id = :user_id"), user_id=12)
```
It seems the current implementation only supports `pyformat` style
```python
result = connection.execute("SELECT * FROM users WHERE id = %(user_id)s", user_id=12)
Contributor guide
Assessment
This issue has not been assessed yet.