Most of the time database is so big that you can't remember where is the specific field or column or which table contain it. so i bring a simple solution for you . Here is the detail of finding a column from database schema.
WEB API is very flexible feature provided by Microsoft. you can expose your data using WEB API over HTTP. send and receive data on different platforms regardless platform compatibility.
By using WEB API you may face issue that how define two GET or POST methods inside a single controller. yes this is possible and using Attribute routing you can achieve this goal.
So please pay attention. you need client requirement to show google results in his website... so what are the possible solutions to achieve this goal? Redirect user to Google and ask theme to write query their and search for it ? i think we are not completing our client requirement. So here is the solution.