[CALCITE-6156] Add ENDSWITH, STARTSWITH functions (enabled in Postgres, Snowflake libraries)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 04/Dec/23 23:49
• Updated: 06/May/24 22:19
• Resolved: 21/Dec/23 22:10

Description

Calcite already offers BigQuery's STARTS_WITH and ENDS_WITH functions. Postgres offers these functions as well. Snowflake offers two very similar functions (the only difference being the naming).

Examples of each function can be found in their original implementation commit 742d477

There will also need to be a small change necessary since Snowflake uses ENDSWITH and STARTSWITH as the function names.

Issue Links

• relates to: CALCITE-6172 Allow aliased operators to re-use existing tests
• links to: GitHub Pull Request #3565