Since you say that you are a beginner with both Go and SQL, I’m wondering if what you say you want to do and what you actually need to do are vastly different things.
Some more details would be helpful. Are you trying to RESTify an existing system? Do you have any examples of your API endpoints and associated queries?