is_unique throws error on not found field

I found the issue, it was a silly typo on the table name I was using users.username instead of Users.username. But the error thrown was not helpful to find it , but it kind of gave the clue. Coding in ci4 is a like a detective's job!