First of all, thank you so much for the new Full-text Search feature! :)
In our team, we would really love the following more advanced features, if possible, related to it:
- Fuzzy matching: it would allow searches to be resilient to common typos and misspellings.
- Prefix matching: it would enable users to find words that start with a specific string of characters, such as "invoic" returning "invoice," "invoices," and "invoicing."
- Column-Specific Search: Instead of searching across all marked "searchable" columns, I would like to choose to focus a specific query on a specific subset. This would be useful to our catalog feature where we have suggestions that, when clicked, should search only on a specific column. At the state of art, the only way possible to obtain this would be to create different tables.
- Getting All Results When the Query is Empty: When the search bar is empty, the system would display all data in the selected table or view. At the current state of art, this is only possible by creating two separate queries: one for the empty search bar, and one when the search bar has a query on it.