Open
Description
When creating an Array type column, the contains operation is not supported.
To reproduce
from sqlalchemy import ARRAY, String
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
class Base(DeclarativeBase):
pass
class Sample(Base):
__tablename__ = "sample_table"
sample_field: Mapped[list[str]] = mapped_column(ARRAY(String(20)), nullable=False)
...
stmt = select(Sample).filter(Sample.sample_field.contains("test"))Error
NotImplementedError: ARRAY.contains() not implemented for the base ARRAY type; please use the dialect-specific ARRAY type
Going through the spanner dialect code, I could not find any array type I could import.
Metadata
Metadata
Assignees
Labels
Issues related to the googleapis/python-spanner-sqlalchemy API.Issues related to the googleapis/python-spanner-sqlalchemy API.