Summary

Databend's inverted index currently offers full-text search for String type, but its support for Variant type is limited. We request an enhancement to the inverted index to provide robust support for Variant type, specifically enabling:

• Targeted Matching: Perform fuzzy or exact matches on specified internal fields within a Variant column.
• Multi-field Conditions: Combine search conditions across one or more nested fields.
• Comparison Operators: Support MATCH or QUERY functions with operators like equals (=), not equals (!=), greater than (>), and less than (<) for indexed nested fields.