For my UWP and android apps, I started my project using firestore DB to store some user addresses and some business data, approximately 1M users data. Unfortunately, I missed to know in advance, that it does not support full-text search. What I mean is, if I search "pha", it should return "elephant" as a result of a search query. But it does not support this type of search. So now searching for another cloud db solution. Please help me to choose a cloud DB that is able to query with full-text search. What I mean for Cloud db is a database, that is offered by Google-like companies, like the ones mentioned here.
Note: I preferred the (firestore)no-SQL DB only because of the running cost of cloud SQL. Google says Cloud SQL pricing is composed of the following charges: CPU and memory pricing, Storage and networking pricing, Instance pricing
My users don't access my cloud-db every hour, If I choose Cloud SQL, I think I may have to pay for CPU charges, every hour, throughout the billing period, though my users use it or not. This is not the case with firestore DB. So I chose firestore db. Other than that. No other specific reason. Please correct me if I am wrong.