My 9 speed era tiagra triple FD works great with brifters, so a Sora 9 speed could be fine. Heck even the ultegra might be ok.
the main issue is getting a smaller chainring setup.
Get lots of ideas and prices and hopefully a local mechanic can be willing to offer non standard suggestions.