Database validation equal / not equal to

Howdy everyone.

Can we have server connect validation that can check if a row equal to another row or equal to a custom literal text? I can achieve what I want using walkaround like by using condition then manipulate other validation to output the message but I wish it can be done in a proper way.

Usage case:

I want to use validation to disable login to account with status inactive, so that I can output the message ‘account is inactive’ on the spot without having the login page to load or redirect.

Let me know if this feature already available or consider it as a feature request.

Thank you.