When FP? and When OOP?

SQL is not a functional language. Sure, it's non-OO, in the sense that data structures don't encapsulate functionality, but so is C.