Now that SQL DATE type is available implement CURRENT_DATE similar to CURRENT_TIMESTAMP and add its aliases CURDATE AND TODAY. Part of #37927