Check out example codes for "insensitive case match sqlalchemy". It will help you in understanding the concepts better.

Code Example 1

from sqlalchemy import func
user = models.User.query.filter(func.lower(User.username) == func.lower("GaNyE")).first()

Learn ReactJs, React Native from akashmittal.com