Condition on Startswith Function Now Can Uses Primary Key

Why it matters

This feature allows conditions using the startsWith function to be applied directly on primary key columns, improving query optimization and performance by enabling index usage for such queries. It solves the limitation where startsWith filters could not leverage primary key indexes, as documented in issues #5310 and #5882.

How to use it

Users can write queries with conditions like WHERE startsWith(primary_key_column, 'prefix'), and the system will use the primary key index to efficiently filter data without additional configuration.