[FEATURE]: Detect incompatible SQL UDF declarations

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Problem statement

..

### Proposed Solution

..

### Additional Context

_No response_