improvement list @stage display filename

[wubx]

list @stage
┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│                                              name                                             │   size   │                 md5                │         last_modified         │      creator     │
│                                             String                                            │  UInt64  │          Nullable(String)          │             String            │ Nullable(String) │
├───────────────────────────────────────────────────────────────────────────────────────────────┼──────────┼────────────────────────────────────┼───────────────────────────────┼──────────────────┤
│ event/data_ce64afc9-5929-47e6-81c0-b8bff0e9ea96_0000_00000000.parquet           │  1345868 │ "bda1b9e03c6b1db0751964959b88b013" │ 2023-07-05 07:49:30.000 +0000 │ NULL             │
│ event/data_ce64afc9-5929-47e6-81c0-b8bff0e9ea96_0000_00000001.parquet           │  1343272 │ "d974cf6940b15d3fbe5e913c37e7c5d7" │ 2023-07-05 07:49:30.000 +0000 │ NULL             │
│ event/data_ce64afc9-5929-47e6-81c0-b8bff0e9ea96_0000_00000002.parquet           │  1344374 │ "26aa1a2db7140704354c70f56381b876" │ 2023-07-05 07:49:30.000 +0000 │ NULL             │
│ event/data_ce64afc9-5929-47e6-81c0-b8bff0e9ea96_0000_00000003.parquet           │  1341249 │ "7699ab1889570b8600cced88afb7a8d0" │ 2023-07-05 07:49:30.000 +0000 │ NULL             │
...
│ event/data_ce64afc9-5929-47e6-81c0-b8bff0e9ea96_0000_00000004.parquet           │  1339019 │ "d39ecd55df0c78fc2e9bd204515d6850" │ 2023-07-05 07:49:30.000 +0000 │ NULL             │
│ 517136 rows                                                                                   │          │                                    │                               │                  │
│ (40 shown)                                                                                    │          │                                    │                               │                  │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
517136 rows in 50.672 sec. Processed 517.14 thousand rows, 505.02 KiB (10.21 thousand rows/s, 1.81 MiB/s)

unload stage with many file, but I only need to know which directory in the path.

let me look into the other product implementations later.

[BohuTANG]

I use:

SELECT
  left(name, 5) AS n
FROM
  list_stage(location = > '@stage')
GROUP BY
  n