[Sqlalchemy-tickets] Issue #3656: Firebird dialect doesn't quote column names properly (zzzeek/sqlalchemy)

[zoomorph <iss...@bi...>]

New issue 3656: Firebird dialect doesn't quote column names properly
https://bitbucket.org/zzzeek/sqlalchemy/issues/3656/firebird-dialect-doesnt-quote-column-names

zoomorph:

class Studio(Base):

    __tablename__ = 'studios'

    sid = Column(Integer, primary_key=True)
    value = Column(String, nullable=False)


SQLAlchemy generates "SELECT studios.sid, studios."value" FROM studios;"

This doesn't work. It appears (first time using Firebird so not too sure) that all column names must be quoted, otherwise I get an "unknown column" error.

I've temporarily worked around it by adding force=True arg to sql\compiler.py line 645  (and modifying line 2704 to actually use this argument).