That seems weird... is it too hard to feed everything into an Elasticsearch index? Even with default settings and some decent hardware you'd get good stemming and relevance ranking pretty easily.
No idea. You could type SQL into searches, but then you had to go somewhere (no idea where) and look up the tables or entities to query. I mean... really?