What is SARGable predicates in Query Optimization?

SARGable predicates is an important concept in Query Optimization. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.