[FEATURE] Return value of regexp function should be boolean instead of integer in V3

[LantaoJin]

Is your feature request related to a problem?
Spark (and Postgre):

spark-sql (default)> select name regexp '.*' from employees;
true
true
true
true
true
true
true

MySQL and OpenSearch SQL v2:

+------------------+
| name regexp '.*' |
+------------------+
|                1 |
|                1 |
|                1 |
|                1 |
|                1 |
|                1 |
|                1 |
+------------------+

What solution would you like?
In V3 (With Calcite), the behaviour will align with SparkSQL.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.