Flask-SQLAlchemy:从所选行获取列名列表，其中value等于某个值

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = '数据库连接URL'
db = SQLAlchemy(app)

class YourModel(db.Model):
    __tablename__ = 'your_table_name'
    id = db.Column(db.Integer, primary_key=True)
    column1 = db.Column(db.String(255))
    column2 = db.Column(db.String(255))
    # 其他列...

columns = [column.key for column in YourModel.__table__.columns]

value = 'your_value'
filtered_columns = [column for column in columns if getattr(YourModel, column) == value]