Summary
SQLSpec 0.51 includes sqlspec.adapters.arrow_odbc, but the adapter package does not include an events/store.py implementation. Other queue-capable adapters expose sqlspec.adapters.<adapter>.events.store, which gives downstream integrations a dialect-specific DDL mirror.
Why
Arrow ODBC can target multiple ODBC databases, so consumers should not assume generic SQL DDL is valid. A first-party events queue store, or explicit upstream documentation that this adapter is intentionally unsupported for events queues, would give integrations a clear contract.
Scope
- decide whether
arrow_odbc should support SQLSpec Events queue storage
- if supported, add
sqlspec.adapters.arrow_odbc.events.store
- detect or normalize the ODBC target dialect from config or driver metadata
- define table and index DDL for supported target dialects
- document unsupported target behavior
- add tests covering dispatch and at least one runnable ODBC target
Related
Downstream queue backend support is tracked separately at cofin/litestar-queues#5.
Summary
SQLSpec 0.51 includes
sqlspec.adapters.arrow_odbc, but the adapter package does not include anevents/store.pyimplementation. Other queue-capable adapters exposesqlspec.adapters.<adapter>.events.store, which gives downstream integrations a dialect-specific DDL mirror.Why
Arrow ODBC can target multiple ODBC databases, so consumers should not assume generic SQL DDL is valid. A first-party events queue store, or explicit upstream documentation that this adapter is intentionally unsupported for events queues, would give integrations a clear contract.
Scope
arrow_odbcshould support SQLSpec Events queue storagesqlspec.adapters.arrow_odbc.events.storeRelated
Downstream queue backend support is tracked separately at cofin/litestar-queues#5.