What is the problem the feature request solves?

We have native right pad (string function) support in comet and no support for left pad support . The goal is to implement a native function to support lpad

Describe the potential solution

Implement a new string function lpad native to comet (in similar lines of rpad)

Additional context

No response