python sqlalchemy oracle 中文_Oracle和SQLAlchemy联接存在区分大小写的错误

我有一个Oracle 11g数据库，我用SQLAlchemy 0.9.7查询，我的数据库有一个表调用网关，它有一个主键列，名为id_gateway，区分大小写，所以我必须像这样手动查询：SELECT "id_gateway" FROM gateway;

我有个疑问：

^{pr2}$

编辑了，因为我选择了错误的查询。

我得到一个错误：*** sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-00904: "GATEWAY"."ID_GATEWAY": invalid identifier

这是表的模式：class Gateway(Base):

__tablename__ = u'gateway'

id_gateway = Column(String(6), primary_key=True)

url_produccion = Column(String(255), nullable=False)

url_implementacion = Column(String(255))

lang_es = Column(String(5))

lang_en = Column(String(5))

t_psp_config = Table(

u'psp_config', metadata,

Column(u'id', String(20), primary_key=True),

Column(u'id_productora', ForeignKey(u'productora.id_productora'), nullable=False),

Column(u'merchant_id', String(20)),

Column(u'email', String(255)),

Column(u'merchant_id_sc', String(20)),

Column(u'id_gateway', String(6)),

Column(u'debug', Numeric(1, 0, False)),

Column(u'moneda', String(10)),

Column(u'pais', String(20))

)

class DefaultFormaPagoWeb(Base):

__tablename__ = u'default_forma_pago_web'

__table_args__ = (

ForeignKeyConstraint(

[u'id_gateway', u'id_forma_pago'],

[u'forma_pago_x_gateway.id_gateway', u'forma_pago_x_gateway.id_forma_pago']

),

)

id_forma_pago_web = Column(Numeric(scale=0, asdecimal=False), primary_key=True, nullable=False)

id_productora = Column(ForeignKey(u'productora.id_productora'), primary_key=True, nullable=False)

id_forma_pago = Column(String(20), primary_key=True, nullable=False)

id_gateway = Column(String(20), primary_key=True, nullable=False)

cuotas = Column(Numeric(scale=0, asdecimal=False), primary_key=True, nullable=False)

diferencial = Column(Numeric(8, 2))

es_porcentual = Column(Numeric(1, 0, False))

forma_pago_x_gateway = relationship(u'FormaPagoXGateway')

productora = relationship(u'Productora')

如何将此表与区分大小写的列联接？在