[GianFabien]

Similar angst was commonly expressed back in the days when high level languages were replacing assembly language and also when OOP was intruding upon FORTRAN, COBOL spaces.

With each technological advance we are able to work at a higher level of abstraction. As you already suggest, broadening your knowledge to domain specific areas is a good idea.

>people will be able to build their own applications Not so fast. Most people aren't willing to spend hours learning prompt engineering to get the latest tools to produce a correct application program that covers all the edge-cases, security and privacy requirements, meet performance targets, etc.

Application systems builders for specific domains will still be in demand. You will need both domain knowledge/expertise as well as prompt engineering (or whatever it is going to be called) skills to have the tools produce exactly what is required.