> wouldn't this something that would be more appropriate to be done at the filesystem level?

Sometimes? You've gotten a ton of replies digging into the "why" and "when", and I only wanted to add that your question brought to mind this quote from the official SQLite website:

> "Think of SQLite not as a replacement for Oracle but as a replacement for fopen()"

https://www.sqlite.org/about.html