Near Protocol and Polkadot are the Future of Blockchains.
Solidity and Rust for EVM-based ecosystems.
Java and Typescript (SvelteJS) are here to stay.
Data is forever, so Postgres and other SQL based languages will always pay-off.
The first requirement of clean code is that it must work. All your optimizations and ornaments are futile if your code doesn't run.
"I dont write clean code from the start, I dont think anyone could.."
-Uncle Bob