So I was using the

SELECT * FROM file WHERE path like '/Users/<user>/%

query as example to demonstrate what I was seeing