[SPARK-3379] Implement 'POWER' for sql 

Add support for the mathematical function "POWER" within spark sql. Test-cases included.
Spitted from [SPARK-3176].
Add `null` as input also?