opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

✨ Rewrite STARTSWITH and ENDSWITH as operators

Open joocer opened this issue 8 months ago • 0 comments

Like we rewrite a LIKE '%s%' to a InStr 's' rewrite so that starts and ends are special internal operators (ones that users can't use)

StartsWith IStartsWith NotStartsWith INotStartsWith EndsWith IEndsWith NotEndsWith INotEndsWith

This could take advantage of not building arrays of constants, not casting to numpy, which is approximately 12 seconds on 100m rows.

joocer avatar Mar 03 '25 20:03 joocer