sql-code-intelligence provides more accurate and detailed information for function completion. However, in order to achieve this, we need function definition in SQL.

sql-code-intelligence has a mechanism that enables engineers to do this job.