Getting Mac Air m2/m3/m4 is it good [D]

A user is considering switching from a Vivobook with an RTX 3050 to a MacBook Air for Python programming, SQL, and LLM frameworks. Their budget is 80,000-1 lac rupees ($800-$1000), with second-hand options open. They are seeking advice on whether to purchase an M2, M3, or M4 model, noting that an M5 is likely out of reach unless significant offers are available.

This discussion uniquely focuses on the specific needs of Python, SQL, and LLM development when choosing between MacBook Air M2, M3, and M4 models, unlike general consumer advice.