TDQM (Teradata Query Manager) is the tool used to manage and restrict queries based on defined thresholds such as execution time, resource usage, or other performance criteria. It acts as a governor for query execution. Teradata Manager provides monitoring but not threshold-based restrictions, while BTEQ and SQL Assistant are query tools.