Uploading assets is only possible in the root folder. It's not possible to upload files in a folder or nested folders. Doing so will result in an error at upload time.
MySQL 5.7.x does not support the
WITH RECURSIVE expression, which is required to fetch the folder hierarchy. This expression was introduced in version 8.0.