Have a look at opencore legacy patcher https://dortania.github.io/OpenCore-Legacy-Patcher/ it will allow you to run Sonoma on your macbook air 2017 and should give you the required compatibility.
As for performance, I'm using it on a 4GB 2015 macbook air (11 inch) with no issues at all. I've event done some C++ development with it.