Using fsdir and .mode columns on windows cuts the name column just after the name/dir specified as parameter:

SQLite version 3.32.3 2020-06-18 14:00:33
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .mode columns
sqlite> SELECT name FROM fsdir('C:\one\two\three');
C:\one\two\three
C:\one\two\three
C:\one\two\three
C:\one\two\three
C:\one\two\three

sqlite> .mode list
sqlite> SELECT name FROM fsdir('C:\one\two\three');
C:\one\two\three
C:\one\two\three/four
C:\one\two\three/four/five
C:\one\two\three/four/five/six
C:\one\two\three/four/five/six/testfile.tmp

Philip