This is non-standard and highly dependent on the sql engine. If you believe in portability, your where clauses should (sadly) use the long form. If that's not

This is non-standard and highly dependent on the sql engine. If you believe in portability, your where clauses should (sadly) use the long form. If that's not a requirement, this approach can add some clarity