Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature: Align TRIM Functions with Snowflake Syntax (TRIM, LTRIM, RTRIM) #16798

Closed
inviscid opened this issue Nov 8, 2024 · 0 comments · Fixed by #16802 or #17375
Closed

Feature: Align TRIM Functions with Snowflake Syntax (TRIM, LTRIM, RTRIM) #16798

inviscid opened this issue Nov 8, 2024 · 0 comments · Fixed by #16802 or #17375
Labels
C-feature Category: feature

Comments

@inviscid
Copy link

inviscid commented Nov 8, 2024

Summary

The current syntax for using TRIM() requires composing a text base value within the function call. This diverges from the Snowflake syntax for TRIM, LTRIM, and RTRIM. For example:

SELECT TRIM(LEADING 'xxx' FROM 'xxxdatabend' );

This also creates problems when trying abstract away from direct SQL statements such as the use of SQLAlchemy. Ideally, the trim operations can be called with a clear function call like:

SELECT LTRIM('xxxdatabendxxx', 'x')

This would align with both Snowflake and Postgres syntax better.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-feature Category: feature
Projects
None yet
1 participant