Automatically suggest & autocomplete tags in StyledInputTags component

[SudharakaP]

This was suggested at, #4764 (comment)

Currently when creating a new tag the user won't be notified if there's similar tags. For example if the user misses that we have a tag called open source they might create another tag called open-source or openSource etc which result in duplicate tags.

Ideally we should search for existing tags when the user types on the tag creation input and then show similar tags (partial matches, ignoring punctuation and accents) and let the user choose that tag if they wish.

We already have the TagStatsCollectionQuery on the API side so what we need to do is,

• Whenever the user types something on the tag creation input we query the tags based on that term and show all the tags that is returned in the tag dropdown.

cc: @Betree

[gustavlrsn]

Updating the title for the issue to also include suggested tags (based on popularity) before typing something in and starting to filter down, something like this:

[gustavlrsn]

To make this query performant, I'm thinking we want to use a Materialized view that returns tags sorted by their count. The current TagStatsCollectionQuery is looking through all Collective's to unnest tags, a quite expensive query to do in an autocomplete field.

[Betree]

Sounds like a very good use case for materialized views, especially since we really don't need fresh data.