issues
search
ydb-platform
/
ydb-sqlalchemy
YQL Dialect for SQLAlchemy
Apache License 2.0
19
stars
5
forks
source link
SQLAlchemy for YDB
#2
Open
asmyasnikov
opened
1 year ago
asmyasnikov
commented
1 year ago
Roadmap:
[x] #5
[x] dbapi:
[x] OLTP (use execute instead of scan_query)
[x] support yql statements with parameters (declare generation)
[x] tests
[x] #15
[ ] support transactions: commit/rollback/tx_mode
[x] support ddl statements (create/drop table)
[x] support dml:
[x] select:
[x] where/filter
[x] #6
[x] distinct
[ ] view (support index)
[x] join
[x] group by
[ ] limit/offset
[ ] support scan query
[ ] insert
[x] simple insert (one row insert)
[ ] inserts multiple rows - generate unify query (as an option use List<Struct<..>> with as_table)
[x] update
[x] delete
[ ] upsert
[ ] replace
[ ] types:
[x] Bool
[x] Integer/Int64
[ ] Int8, Int32
[ ] Uint8, Uint32, Uint64
[x] Double
[ ] #12
[ ] #13
[x] Utf8
[x] Uuid as Utf8
[ ] Json, JsonDocument
[ ] Yson
[x] Timestamp
[ ] #7
[x] Date
[ ] List
[ ] Set
[ ] Tuple
[ ] Dict
[ ] Struct
[ ] Enum
[x] #9
[ ] support transactions commit/rollback/mode
[x] support sqlalchemy v2 (
https://docs.sqlalchemy.org/en/20/
)
[ ] asyncio support (
https://docs.sqlalchemy.org/en/20/orm/extensions/asyncio.html
)
[ ] benchmarks (native driver vs sqlalchemy)
[ ] demo application
[ ] slo
[ ] #11
[ ] #14
Roadmap: