SQL: Implement CURTIME()/CURRENT_TIME()

[matriv]

Now that SQL TIME type is available implement CURRENT_TIME similar to CURRENT_TIMESTAMP and add its alias CURTIME .

Part of #33092

[elasticmachine]

Pinging @elastic/es-search

[matriv]

Backported to 7.x with f3c207d