This is an epic issue to enhance the substring kernel from performance, safety and supported types.
You can find more info from the discussion: #1529 (comment)

List of individual tasks is below:

Performance

• Speed up the substring kernel by about 2x #1512
• Speed up substring_by_char kernel #1800

Safety

• Improve doc string for substring kernel #1529
• Add utf-8 validation checking for substring #1577
• Bug (substring kernel): The null buffer is not aligned when offset != 0 #1639

New Features

• Add substring support for binary #1608
• Add substring support for FixedSizeBinaryArray #1618
• Add dictionary array support for substring function #1656
• Add substring_by_char kernels for slicing on character boundaries #1768
• Add support for list array
• The substring kernel should support FixedSizeListArray  #1887
• Add support for map array