how to define the query for findBySearchTerm?

[WalkerWalker]

sorry for this naive question. I am not sure how to define the query for findBySearchTerm. Currently I am doing something like the following, but I guess it should be more powerful? Thank you in advance.

select id, username, email, first_name as "firstName",last_name as "lastName" from auth_user where username like (?)

[WalkerWalker]

any help