So basically what I'm trying to do is
class Object:
    _our_name = type(self).__name__
    __tablename__ = _our_name
    uid = Column(Integer, Sequence(_our_name + '_id_seq'), primary_key=True)
    name = Column(String, unique=True)
but of course I can't use self in this case. How would I do this?

'Object'._our_namestuff to be replaced with the subclass name, for each subclass? It sounds like you'd be better served by a class factory of some sort.