René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Array contains operation is not supported","articleBody":"When creating an Array type column, the contains operation is not supported.\n\n### To reproduce\n\n```python\nfrom sqlalchemy import ARRAY, String\nfrom sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column\n\nclass Base(DeclarativeBase):\n    pass\n\nclass Sample(Base):\n    __tablename__ = \"sample_table\"\n    sample_field: Mapped[list[str]] = mapped_column(ARRAY(String(20)), nullable=False)\n\n...\n\nstmt = select(Sample).filter(Sample.sample_field.contains(\"test\"))\n```\n\n### Error\n\n```\nNotImplementedError: ARRAY.contains() not implemented for the base ARRAY type; please use the dialect-specific ARRAY type\n```\n\nGoing through the spanner dialect code, I could not find any array type I could import.","author":{"url":"https://github.com/csibe17","@type":"Person","name":"csibe17"},"datePublished":"2025-03-07T10:13:23.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/613/python-spanner-sqlalchemy/issues/613"}