SQLAlchemy for YDB

[asmyasnikov]

Roadmap:

• use "dialect compliance suite" for testing #5
• dbapi:
  • OLTP (use execute instead of scan_query)
  • support yql statements with parameters (declare generation)
  • tests
  • Validate exception ydb.driver to dbapi mapping #15
  • support transactions: commit/rollback/tx_mode
• support ddl statements (create/drop table)
• support dml:
  • select:
    • where/filter
    • Support match by regexpr #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
  • Support Decimal/Numeric data type #12
  • Support Binary/String datatype #13
  • Utf8
  • Uuid as Utf8
  • Json, JsonDocument
  • Yson
  • Timestamp
  • Support Interval (datetime) datatype #7
  • Date
  • List
  • Set
  • Tuple
  • Dict
  • Struct
  • Enum
  • support NULL #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
• Support alembic migration tool #11
• SuperSet integration #14