With such description you provided, it would be difficult to determine the source of the pain without being examined and no due investigation. Much more we cannot say if such pain will eventually go or not.
There are many possibilities for the cause of your pain which include gastrointestinal problems such as ulcers , irritable bowel syndrome, GERD, problems in pancreas, renal stone, or possibly diverticulitis.
The unbearable sharp pains per your description makes me suspect more of renal stone however it is also possible that pain could be any of the possibilities as mentioned above.
I know, you are not so inclined to see a doctor, but with such sharp pains you had been experiencing, it would be at your best interest to see a doctor. Please don't let your self to suffer from such pain and besides it is better to find the cause to be sure it is not something serious. When the cause is treated, then that is the time we can tell if the pain will go or not.
Renal stone is usually on one side but it is also possible to be on both sides if both kidneys have stone formation. I can tell that renal pain is pretty intense and topical analgesics won't be of much help. Mild analgesics are usually not so helpful. Any pain pills may not be so helpdful as well because the effect is not immediate. Analgesics given by injection usually provide temporary quick relief.
Ifever there is a presence of renal stone, the pain will persist as long as the stone is not released from the kidney.
By the way just to clarify that a suspicion on kidney pain as the source of your pain is not definitive. As I mentioned earlier, there are many other possible causes to be considered as the possibility.