Special characters and word AND in CQL queries

Summary

We are working on an app for Confluence and are using the search REST api using CQL. We are facing challenges with escaping the special characters (related to https://developer.atlassian.com/cloud/confluence/cql-functions/)

Use Case

1. Use contains operator
2. Use a Special character
3. Multi-character wIldcard search

I have a page with title "Parties @MJs". I have tested searching with the REST API browser with the following results:

The following examples return the page as a result

title='Parties @MJs'

title ~ 'Parties @MJs'

title ~ "Parties MJ*"

title ~ "Parties @"

The following examples do not return results

title ~ 'Parties @M*'

title ~ "Parties @M*"

title ~ 'Parties @M'

Notes

I would really appreciate if you can raise the request to not have this limitation. If it is considered a limitation and not a bug, maybe it could be added into the documentation as well.

Search functionality is an important feature in our app. We have 3.5k installations.

I can also verify that this does not work in cloud either.