Currently, "field.startsWith( 'beginningWith')" is compiled as
LOCATE(CAST(<'beginningWith'> AS VARCHAR(32672)),THIS.field) = <1>
which scans the whole table!
We work around that by using "field.matches( 'beginningWith.*')" instead, which is currently compiled as
THIS.field LIKE <'beginningWith%'> ESCAPE '\'
"field" can be indexed, and the performance gain is big!
Can "startsWith" also be compiled as "like" please?