cloudflare / cloudflare/sqlalchemy-clickhouse

Support sqlalchemy style parameterized queries

Open
#37 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.