Just declare columns you need and don't use fromDatabase:

class MyTable(SQLObject):
  name = StringCol(dbName="a$name")
  value = IntCol(dbName="the$value")

Yes, I remember I was trying such a syntax at the begening but SQLObject was complaining about ID generator and I was not able to solve it.

kinterbasdb.ProgrammingError: (-104, 'isc_dsql_prepare: \n  invalid request BLR at offset 73\n  generator GEN_CENKTGM01 is not defined')

(really trying to search the doc etc. and googling a lot before this posting/reply... sorry).