`SELECT ... WHERE match(key, '^prefix...')`
should use index similarly to
`SELECT ... WHERE key LIKE 'prefix%'`
{
        if (ast)
        {
            
            String column_name = ast->getColumnName();
            if (const auto * lit = ast->as<ASTLiteral>())
            {
                
                
                
                if (!block_with_constants.has(column_name))
                    column_name = "_dummy";
                
                out_value = lit->value;
                out_type = block_with_constants.getByName(column_name).type;