Under Review

Search subfolders for a specific filename or extension.

Useful query to search entire subfolders for a specific extension or a filename. Supports wildcards in path and filename.

SELECT
  path,
  directory,
  filename,
  device,
  size
FROM file
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.