Support for ANSI SQL syntax in TRIM function
Open
@nishithakbhaskaran is already working on this.
Since Aug 17, 2026.
feature request
- Dominant language
- Java
- Stars
- 16.7k
- Forks
- 5.5k
- Avg merge
- 2d 15h
- Merged PRs (30d)
- 66
Description
Expected Behavior or Use Case
Support the below syntax in trim function
TRIM(BOTH | LEADING | TRAILING FROM <source>)
TRIM(BOTH | LEADING | TRAILING <char> FROM <source>)
TRIM(<source>, <char>) -- existing comma form, unchanged
Presto Component, Service, or Connector
Possible Implementation
Example Screenshots (if appropriate):
Context
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.