I have already done some try there (Mathing String) and with q.any_of or q.all_of to mix with ilike query (Cause i need casefold search) . But where i stuck is i need to lookup if each in a array can be found in any collumn. each term in the array need to be found or is not a valid result. think a a search bar more term you add more precise the search is.
maybe is some way to search on a concat field via the orm ? duno. but yes i have read several time this documentation you link thank @alcampopiano
EDIT:
In fact the q.full_text_match could be perfect but it search on only one column the difference is all term need to match but this can be from some collumn not only one.