Comment by vajrapani666

You can use custom queries in metabase and parameterize them, for any parameter you can expose the parameter with a text field available when you embed the "question" anywhere.

https://hevodata.com/blog/postgresql-full-text-search-setup/