It's probably cheaper and simpler to modify (say you suddenly want it to turn on when you click 3 times) to use a 0.1€ chip than to figure out how to do it and build it with discrete components.
20 years ago I was all "computer (chips) can do everything! We can use them everywhere! Replaceable, reprogrammable, fantastic!"
And no one cared.
Now they are everywhere and it's just a fucking mess 😔
Maybe 20 years from now the EU will have forced standards onto everything and you can (again) fix your dishwasher (and start it from work!!1!).
You make me remember that girl making a painting of a greek man taking residence in front of her shower, charging her to use it, because she dreamt it.
Sure, but many languages do that, see my answer below. I just personally wouldn't recommend either lisp or haskell to someone learning how to program. There are more modern and better ways, IMO.
Flexibility? Have you tried c++ 😁, check out template meta programming, and voilà rusts static memory management and compile time error checking in c++.
What I want to say is you don't need this or that language to grasp functionality, and IMO heskel and lisp probably have more interesting and modern counterparts, if you feel the need.
Edit, forgot you're not OP so my answer is potentially a bit wonky, sorry about that.
Why in your opinion do you think any person who wants to understand programming "deeply" (I'm not exactly sure what you mean with that) should learn lisp and haskell? It seems way way unnecessary.
And then you throw in SQL. Sure why not, but then why not javascript, Lua, c++, rust, PHP and a whole load of others who will teach you something unique most probably.
Ooh been there done that, but with opengl, lol memories...