First and foremost, I 100% agree that Search needs some improvement and that it is currently one of Fibery’s key problems. I definitely think some others are ahead of it for broad adoption, general UI/UX stuff, arguably bi-directional sync, and other things. But Search is definitely in the top 5 for me, at least.
So on to your proposal. This is some cool imagining! But it is really a pretty massive collection of not-necessarily-related or interdependent features, from Dynamic Filtering, to Saved Searches, to changes/improvements in Search Indexing, to entirely changing the Search UI to basically be a View. Any one of those could make a good feature request, but I think if you’re hoping to get support for this single post as a “Feature Request”, you may have a hard time. This topic might do better in another Category for more general ideation and discussion rather than as a voted set of specific features/ideas for a new Search UI.
That said I do particularly love the idea of having Fibery Search optionally be a sort of temporary (or not so temporary, e.g. for Saved Searches) “View”, because what you’re showing is basically just visualizing the Search Results in a Table/Grid type of view. If search results as they are now can be sort of “piped” easily to a Grid (or other View?), that could go a long way toward making this possible and solving some of the technical issues. The UI/UX around all of this could still be challenging, but the potential for Grid improvements to affect Search Results functions is exciting. For example Grid does not currently support dynamic Filtering per-column but hopefully one day it will! And if/when it does, that could then immediately be available in Search. I’d love that.
From my external position, not knowing much of how Fibery works in the back-end, it does seem quite promising and not that hard to basically work on a way of temporarily instantiating Views that search/filter on the entire Workspace. That said I know there are already limits on what can be included in each View, so e.g. including all ~50+ DBs that many people (like me) have in a single View could be a performance issue on its own (for a full Grid UI; obviously existing Search already supports all DBs). Search also only indexes certain fields, however I’d personally be happy just getting a more powerful search UI, even with only the currently indexed fields.
There is also quite a lot of prior discussion on Search and how to improve it, including some more specific Feature Request topics that cover some of your ideas to some degree, and have existing votes:
Isn’t YAML basically just “fields for Markdown” (some/all of which are hidden, depending on the UI of the reading app)? Why are people suddenly talking about wanting to support YAML in Fibery when it’s already a full-blown Database application that goes far beyond what YAML does (in some respects)? Maybe I’m not familiar enough with YAML to understand. But again this seems tangential to the topic here…