How do I know if a user's password is expired?

Wondering if there's any way (with SQL) to identify users whose password has expired or is about to expire.. the app doesn't seem to use the ClientUserPasswordHistory table anymore nor is anything obvious stored on the ClientUsers table.