I don't really find these kind of features necessary.

You can, and probably should, do these things in your application code. I mean, it's not really that hard to make a string lowercase, you don't need to define a "virtual colum" for that...

You're right, it's not that hard. But why would you rather do it there?