Useful query to search entire subfolders for a specific extension or a filename. Supports wildcards in path and filename.
WHERE directory LIKE 'C:\users\%\desktop%%' AND filename LIKE '%%.exe'
This solution was proposed by Karl Ackerman to my request how to perform such a discovery. Since then it seems that other users need this type of query too, so here it is.