KQL x EXIST or IN SQL operator

Good morning, I would like to know if it is possible to build a KQL (Keyword Query Language) query to do the same thing as the SQL EXISTS or SQL IN operator or a LIKE *TEXT* to query a property with single value against another property with multiple value