TypeError: unsupported operand type(s) for +=: ‘TextClause‘ and ‘str‘

找遍全网最终在

应用错误收集

这个回答中找到答案，也许不是最优的，但是解决了我的问题

from sqlalchemy import text

db = db_session()
sql = '''SELECT a.id,b.b1 as b1,a.a1,a.a2,a.a3,
                a.a4,a.a5,a.a6,a.a7,a.a8
                FROM a
                INNER JOIN b ON a.aa=b.aa
				WHERE 1=1
                '''
if len(params) != 0:     #传递过来的数组 
    for key, val in params.items():
        if val:
            t = """ and {} like '%{}%' """     #模糊搜索
            sql += t
            sql = sql.format(key, val)
        else:
            sql = sql
    l = """ limit {},{} """
    sql += l
sql = text(sql.format(format(page - 1) * limit, limit))
res = db.execute(sql)