sqlalchemy.schema.DropTable compilation: Table name should be quoted by back quotes (`) on DROP TABLE

[rkawajiri]

Environment details

• Programming language: python
• OS: debian (official docker image python:3.11-bullseye)
• Language runtime version: python 3.11.6
• Package version:
  • sqlalchemy-spanner==1.6.2
  • sqlalchemy==2.0.22

Steps to reproduce

Execute this code.

from sqlalchemy.schema import DropTable, CreateTable
from sqlalchemy.orm import DeclarativeBase, mapped_column, Mapped
from google.cloud.sqlalchemy_spanner import SpannerDialect

class Base(DeclarativeBase):
    pass

class User(Base):
    __tablename__ = 'Users'

    id: Mapped[int] = mapped_column(primary_key=True)

print(CreateTable(User.__table__).compile(dialect=SpannerDialect()).string)
print(DropTable(User.__table__).compile(dialect=SpannerDialect()).string)

then it will print

CREATE TABLE `Users` (
    id INT64 NOT NULL
) PRIMARY KEY (id)

DROP TABLE "Users"

[ankiaga]

PR raised https://github.com/googleapis/python-spanner-sqlalchemy/pull/385