Comment by deepstack

In some way sql programming like functions, cursor, store procedures is the Advance Excel programming. Why reinvent the wheel?

In regards to having JS/Python scripting it, if you using Postgres, just add v8 or python plugin, and there you have your advance excel programming in the language of your choice.