The raw query I'm trying to get plugged in here is:

SELECT * FROM x WHERE CONCAT(y, ' ', x) LIKE '%value%';

I've checked through the query builder documentation and can't find anything that would allow me to do this.