The use of a parameterized query in a lookup makes it possible to lighten the cached data, especially in the case of iterative processing, and that we do not need to load all the data in the cache.
Even if the lookup component does not offer the possibility of using variables but it does have the property SqlCommand which allows to specify the lookup request and which can be configured.