LPS-38220 Simulate SQL like wildcard matching logic

LPS-38220 is going to be long and complex. Please leave the ticket open, I will let you know when all changes are in place.