List folders and files within a folder

Returns entries (files and subfolders) in the given folder. Specify the folder path in the WITH clause or leave defaults to list from root. Use this to browse or feed path options into other operations.

SELECT *
FROM list_folder