However, my main goal for Marmot was to decrease the latency of my website by putting the db as close as I can to the end user
It's about +5M requests per day or ~2B per year. That's on the lower end! The higher end is ~20B requests per year!
I think using distributed SQL for that kind of scale may not be a wise choice, but that's my opinion...
However, my main goal for Marmot was to decrease the latency of my website by putting the db as close as I can to the end user