如何将sqllite或python中的sqlalchemy转换为数字？

import sqlite3
from sqlalchemy import create_engine, select, func

conn = sqlite3.connect('your_database.db')

engine = create_engine('sqlite:///your_database.db')

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String

Base = declarative_base()

class YourTable(Base):
    __tablename__ = 'your_table'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    value = Column(Integer)

# 使用原生SQL查询
result = conn.execute("SELECT value FROM your_table")
values = [row[0] for row in result]

# 使用SQLAlchemy查询
with engine.connect() as conn:
    stmt = select(YourTable.value)
    result = conn.execute(stmt)
    values = [row[0] for row in result]

numeric_values = [int(value) for value in values]