Isn't Jai still mostly a C-like, with manual memory management and other archaic rituals?

See, SQL for example don't care about the hardware or the internals of the database it runs on, why couldn't we have something like that for gameplay?