Add Experimental Inverted Index for Efficient Text Search

Why it matters

This feature introduces an inverted index to improve the performance of text search operations. It addresses the need for faster and more efficient querying of textual data, enabling users to perform secondary index-based searches that can significantly reduce query latency.

How to use it

Users can create an inverted index on a table column by specifying the new secondary index type in the CREATE TABLE or ALTER TABLE statements. Since it is experimental, it should be enabled and used with consideration of current limitations detailed in the documentation.