# What changed in sqlalchemy-cratedb

> 18 changes in sqlalchemy-cratedb 0.43 to 0.44 from its official release notes, upgrade guides and advisories: 3 breaking, 3 new APIs and options. Each one cited. Sources checked 2026-10-25. HTML: https://unstale.sh/pypi/sqlalchemy-cratedb/

To see which of these apply to a repository, run `npx @unstale/cli init` in it.

## sqlalchemy-cratedb 0.44

### Fixes and other changes

- Fixes array positions rendering as object keys. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- CLOB, NCHAR, NVARCHAR, DATETIME and DATE compile to DDL that CrateDB can parse. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- NUMERIC columns are now stored as NUMERIC. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- Fixes subscripts being served from the statement cache. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- Using SQLAlchemy Time no longer raises “Cannot find data type: time” on CrateDB. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- Fixes a TypeError when reading timestamps with the driver's time_zone option. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- Unresolvable reflected types are named, and geo, IP, character and array types are resolved. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)
- UUID values are bound in the dashed form accepted by Crate. (0.44.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.44.0)

## sqlalchemy-cratedb 0.43

### Breaking changes

- CREATE INDEX is now a no-op in the compiler. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)
- The dialect migrates to paramstyle="pyformat", following crate-python 2.2.0. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)
- Support for Python versions below 3.10 is removed. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)

### New APIs and options

- Methods concerned with isolation levels are implemented as no-ops. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)
- Adds the ObjectArray.as_generic method. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)
- PostgreSQL JSON(B) types are emulated using CrateDB's OBJECT type. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)

### Fixes and other changes

- Fixes an AttributeError involving CrateCompilerSA20; the notes do not specify the triggering operation. (0.43.1) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.1)
- FLOAT type support is improved, converging to FLOAT versus DOUBLE. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)
- Compiler calls for ON CONFLICT DO UPDATE are forwarded to PostgreSQL's compiler implementation. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)
- Type mappings are improved. (0.43.0) — [release notes](https://github.com/crate/sqlalchemy-cratedb/releases/tag/0.43.0)