全部转换为小写字符再进行比较
from sqlalchemy import func user = models.User.query.filter(func.lower(User.username) == func.lower("GaNyE")).first()