I'm working with Google Spanner (MySQL) in a FastAPI application and encountering this error when trying to search for a column with search index on (as the docs):

status = StatusCode.INVALID_ARGUMENT details = "SEARCH_NGRAMS cannot be used in transactional queries by default." ... google.api_core.exceptions.InvalidArgument: 400 SEARCH_NGRAMS cannot be used in transactional queries by default.

Iam using Sqlalchemy, that's the query:

    query = '''
        SELECT
        *
        FROM 
        permission p
        WHERE
        1=1 AND SEARCH_NGRAMS(p.Tokens, "alpha")
    '''
        
    engine.execute(query)

Questions:

1- How can I use text search capabilities in Google Spanner within transactional contexts? 2- Is there a way to enable SEARCH_NGRAMS in transactional queries? 3- What are alternatives to SEARCH_NGRAMS for searching text in Google Spanner?