I'm trying to filter a table on a column that contain spaces.
...
events = database_session.query(table)
events.filter(table.column with space == 'xvalue') < -- I want to do that
...
There is for sure a simple way of doing that, but I can't seem to find it anywhere.
@Hans,
There are two ways to resolve this.
When defining the table you would need to specify an alias with the key parameter
t_table_name = Table(
'table)name', metadata,
Column('SQL Column',Integer, key='sql_column'))
Define the ORM class as
class Employee(Base):
emp_name = Column("employee name", String)