Using SQLAlchemy ClauseElement and Expression for Filtering| teradataml - Using Basic SQLAlchemy ClauseElement and Expression for Filtering - Teradata Package for Python

Vantage offers various types of clauses in WHERE clause that allows users to filter the results in a table.

With the help of SQLAlchemy ClauseElements and Expression, teradataml can use the following SQL clauses to filter results in teradataml DataFrame:

• CASE expression
• BETWEEN ... AND ... clause
• IN clause
• NOT IN clause
• LIKE clause
• NOT LIKE clause
• ILIKE clause
• IS NULL
• IS NOT NULL

Refer to example notebook <pkg_install_location>\teradataml\data\notebooks\sqlalchemy\teradataml filtering - Using SQLAlchemy ClauseElements.ipynb to learn about these.