I can’t actually imagine the niche for this tech.

Pet projects with simplest logic? ToDo app examples?

It won’t work in a large scale projects because this approach doesn’t scale well.

On a small scale it adds very uneven comlexity curve. Until some point everything is quite easy, but one day you need to write a stored function in plsql, and it’s not an easy task. Python/js won’t help in this case, because there will no be maturity of nodejs/django in decades.

Why should anyone prefer this thing to Rails?