`select * from file where path like '/home/%%';` w...
# general
t
select * from file where path like '/home/%%';
will recursively get all files in
/home