Skip to content
This repository was archived by the owner on May 14, 2026. It is now read-only.
This repository was archived by the owner on May 14, 2026. It is now read-only.

Support For Multi-Row Inserts #670

Closed

Description

@waltaskew

The dialect currently doesn't support multi-row / bulk inserts, although Spanner itself does.

    engine = sa.create_engine(
        "spanner+spanner:///...", 
    )

    with engine.begin() as conn:                                                                                                                                                                                                                                                
        conn.execute(
            sa.insert(Person)
            .values([{"name": "jdoe"}, {"name": "jmoe"}])
            .returning(Person.id)
        )
        session.commit()

sqlalchemy.exc.CompileError: The 'spanner+spanner' dialect with current database version settings does not support in-place multirow inserts.

Activity

  1. added
    type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.
    priority: p3Desirable enhancement or fix. May not be included in next release.
    on May 28, 2025
  2. added a commit that references this issue on May 28, 2025
    2d94e26
  3. added a commit that references this issue on May 30, 2025
    f5d94cd
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.priority: p3Desirable enhancement or fix. May not be included in next release.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions