Mocking SqlQuery with where condition

Question

I've been following the answer from this link about how to mock sqlquery call, but when I try to replace the query string with a where condition, it return the all of the object in the list instead of the expected filtered list, is it not possible to filter the object by its property name?

var myObjects = _context
                    .Set<myObject>()
                    .SqlQuery("select * myObject where id = '1'")
                    .AsNoTracking()
                    .ToList();