SQLAlchemy for YDB

Roadmap:

• #5
• dbapi:
  • OLTP (use execute instead of scan_query)
  • support yql statements with parameters (declare generation)
  • tests
  • #15
  • support transactions: commit/rollback/tx_mode
• support ddl statements (create/drop table)
• support dml:
  • select:
    • where/filter
    • #6
    • distinct
    • view (support index)
    • join
    • group by
    • limit/offset
    • support scan query
  • insert
    • simple insert (one row insert)
    • inserts multiple rows - generate unify query (as an option use List<Struct<..>> with as_table)
  • update
  • delete
  • upsert
  • replace
• types:
  • Bool
  • Integer/Int64
  • Int8, Int32
  • Uint8, Uint32, Uint64
  • Double
  • #12
  • #13
  • Utf8
  • Uuid as Utf8
  • Json, JsonDocument
  • Yson
  • Timestamp
  • #7
  • Date
  • List
  • Set
  • Tuple
  • Dict
  • Struct
  • Enum
  • #9
• support transactions commit/rollback/mode
• 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

Start by reviewing the unchecked roadmap items in the issue and the linked SQLAlchemy 2.0 asyncio documentation. The roadmap spans transactions, query features, types, async support, benchmarks, and demos, with no files or tests identified. Done is not defined for the overall issue; a contributor would need to select and scope one item first.