Overview of recommended macOS for different devices?

Hey, is there an official recommandation on what macOS version is recommended for what device? I'm about to update an Macbook Air 6,2 with only 4GB memory. I want to update to Ventura at least, and what I've read so far Ventura and Sonoma should work okish. Sequoia seems to be recommended for 8GB memory devices only. Could someone help me with that decision :)?

Author: @gernophil