SQLAlchemy for YDB

[asmyasnikov]

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