to_dict()

        query = DBSession.query(customer)
        for row, obj in enumerate(query):
            json_style_result = obj.to_dict()
            for spam,ham in enumerate(json_style_result):
                sheet.write(row, spam, json_style_result[ham])

query = DBSession.query(contract).join(customer)