CHANGELOG.md

Changelog

PyPI History

1.17.2 (2025-12-15)

Bug Fixes

• Retrieve columns in compound indexes in correct order (#798) (9afe49bb720356c58890931c17546650ffd61f88)

1.17.1 (2025-10-21)

Bug Fixes

• Return Correct Column Order in get_multi_foreign_keys (#783) (42027d5), closes #779

1.17.0 (2025-10-09)

Features

• Add Support for Interleaved Indexes (#762) (77b86f1), closes #761

1.16.0 (2025-09-02)

Features

• Support NULL FILTERED indexes (#750) (4bc0589)

Documentation

• Add sample for parse_json (#752) (b2f0e89), closes #735

1.15.0 (2025-08-19)

Features

• Add license metadata to setup.py (#712) (8f2e97e)
• Enable SQLAlchemy 2.0's insertmany feature (#721) (1fe9f4b)
• Support informational foreign keys (#719) (c565ae1)

Bug Fixes

• Report column defaults in introspection (#744) (309c641), closes #730
• Respect existing server default in alter column DDL (#733) (1f8a25f)

1.14.0 (2025-06-27)

Features

• Support commit timestamp option (#697) (82bb8ed)

1.13.1 (2025-06-20)

Bug Fixes

• Support retrieval of cross-schema foreign keys (ef07a1f), closes #638

1.13.0 (2025-06-05)

Features

• Introduce compatibility with native namespace packages (#375) (052e699)

1.12.0 (2025-06-02)

Features

• Document the use of statement and transaction tags (#676) (c78ad04)
• Support database role in connect arguments (#667) (47aa27c)
• Support multi-row inserts (#671) (f5d94cd), closes #670

1.11.1 (2025-05-27)

Bug Fixes

• Update README to include isolation level repeatable read (#668) (d84daf6)

1.11.0 (2025-05-07)

Features

• Add isolation level support and sample (#652) (0aba318)
• Add SpannerPickleType (#655) (0837542), closes #654
• Support schemas in queries and dml statements (#639) (81c154a)

Bug Fixes

• Column order in get_multi_pk_constraint (#640) (16c87e4)
• Include schema when creating indices (#637) (41905e2)

1.10.0 (2025-03-17)

Features

• Support AUTO_INCREMENT and IDENTITY columns (#610) (f67ebe8)

1.9.0 (2025-02-21)

Features

• Support request and transaction tags (#558) (c4496fd)

Documentation

• Add test for using FOR UPDATE (#575) (8419ae4)

1.8.0 (2024-12-09)

Features

• Add helper function for insert-or-update (#526) (6ff12ec), closes #391
• Support dml returning (#335) (7db3f37)
• Support float32 (#531) (6c3cb42)
• Support Partitioned DML (#541) (108d965), closes #496

Bug Fixes

• Add existing_nullable usage to visit_column_type (#329) (273f03b)
• Map now() to current_timestamp (#540) (4b24f33), closes #497
• Support storing columns for indices (#485) (93579c8)
• Support THEN RETURN for insert, update, delete (#503) (ac64472)

Dependencies

• Add nh3 (#481) (3c2bcf9)
• Add proto plus (#482) (8663453)
• Update all deps (#413) (25d9d2c)

Documentation

• Add sample for read-only transactions (#533) (d2d72b6)
• Add sample for stale reads (#539) (e9df810)
• Add samples for Spanner-specific features (#492) (a6ed382)
• Cleanup the transaction section of README a bit (#545) (c3b5df5)
• Fix readme typo (#487) (b452b4f)

1.7.0 (2024-02-07)

Features

• Support sequences (#336) (e35a8a0)

Bug Fixes

• Db.params OpenTelemetry integration issue (#346) (0a69031)
• Fixing test for literals due to change in sqlalchemy core tests (#384) (62cccc3)
• Table name should be quoted by back quotes (`) on DROP TABLE (#385) (628d26c)

1.6.2 (2023-05-31)

Bug Fixes

• Disables sequence support (#326) (7b441ff)

1.6.1 (2023-05-23)

Bug Fixes

• Add opentelemetry version (#322) (b80d24d)
• Fix check so it's all lowercase. (#321) (8fae358)

1.6.0 (2023-04-26)

Features

• Enable instance-level connection (#316) (9af8e86)

1.5.0 (2023-04-19)

Features

• Feat: SQLAlchemy 2.0 support (#314) (61d836b)

1.4.0 (2023-04-06)

Features

• User provided client (#311) (5b07111)

1.3.0 (2023-03-20)

Features

• Implement get_view_names() method (#306) (63461e6), closes #303
• Support request priorities (#286) (3aecf2d)

Bug Fixes

• Alembic incompatibility with sqlalchemy < 1.3.11 (#290) (f99f3a7)
• Introspect constraints, keeping their order (#289) (7f65972)
• Test fix (#310) (c376d42)

1.2.2 (2022-10-04)

Bug Fixes

• Adding requirements (#250) (61a13d4)
• Don't introspect internal UNIQUE constraints (#244) (51cdc53)
• Spanner auto managed indexes should not be introspected (#241) (c3b5907)
• Update dialect name for ALTER operation overrides (#234) (f9e8ebe)

Documentation

• Add auto retry mechanism explanation (#243) (68b9bc8)
• Mention autocommit_block as a solution for Aborted transaction … (#239) (f23e599), closes #229
• Mention package install with pip (#245) (528a9b0)

1.2.1 (2022-08-09)

Bug Fixes

• alembic migration fails in case of a sequential upgrade (#200) (f62f664)
• don't reset attributes of non-Spanner connections (#222) (072415e)
• incorrect DDL generated when using server_default (#209) (#220) (7ab1742)

Documentation

• add a note about connection URL prefixes (#219) (a986949)

1.2.0 (2022-06-03)

Features

• allow SQLAlchemy 1.4 use (#198) (7793b7d)

1.1.0 (2022-01-28)

Features

• drop read_only on a connection returned back to a pool (#189) (16388c1)
• rollback a connection returned back to pool (#193) (13ff9cb)
• support SQLAlchemy 1.4 (#191) (029b181)

Bug Fixes

• bump up google-cloud-spanner required version (#171) (33c86e8)
• connection reset fails when an additional dialect is used (#188) (417b8b8)
• delete stale instance with delay of 5 seconds (#194) (2932a02)
• NOT NULL computed column creation failure (#173) (e336735)

Documentation

• add a README section for the autoincremented ids (#180) (4c610ea)
• explicitly recommend uuid to generate PKs (#182) (b10f2ca), closes #181

1.0.0 (2021-12-08)

Features

• add code samples (#55) (406c34b)
• set user-agent string to distinguish SQLAlchemy requests (#116) (b5e1a21)
• support computed columns (#139) (046ca97), closes #137
• support JSON data type (#135) (184a7d5)
• support read_only connections (#125) (352c47d)
• support stale reads (#146) (d80cb27)

Bug Fixes

• ALTER COLUMN NOT NULL directive fails because of inappropriate syntax (#124) (c433cda)
• array columns reflection (#119) (af3b97b), closes #118
• calculate limit value correctly for offset only queries (#160) (6844336)
• correct typo in spanner_interleave_on_delete_cascade keyword (#99) (a0ebf75)
• raise Unimplemented error when creating temporary tables (#159) (646d6ac)
• rollback failed exception log (#106) (809e6ab)

Documentation

• add query hints example (#153) (9c23804)
• reformatted README titles (#141) (a3ccbac)
• update benchmarks (#155) (3500653)

Miscellaneous Chores

• setup release 1.0.0 (#165) (37a415d)