macos – How to convert folders to databases in finder?

I have been lately an intensive Notion user which means that I love databases

So I’m trying to extrapolate that workflow to Finder and I am confident it’s possible via smart folders although I don’t know how to apply it

Could somebody show me how to set the filters inside a smart folder in order to show all the files inside without the ‘structural folders’