Allow Pruning of S3 File List via Virtual Columns

Allow to prune the list of files via virtual columns such as _file and _path when reading from S3. This is for #37174 , #23494. #37356 (Amos Bird).