Make built-in Functions easier to use

[xzdandy]

Search before asking

• I have searched the EvaDB issues and found no similar feature requests.

Description

Currently, for built-in functions that are not loaded at bootstrap time. It is not easier to specify the path to the function in CREATE FUNCTION due to the installation python. Need a better support for built-in functions to improve user experience.

Use case

No response

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!

[xzdandy]

A workaround now is following:

from evadb.configuration.constants import EvaDB_INSTALLATION_DIR
cursor.query("DROP FUNCTION IF EXISTS SiftFeatureExtractor;").df()
cursor.query(f"""
    CREATE FUNCTION SiftFeatureExtractor
    IMPL '{EvaDB_INSTALLATION_DIR}/functions/sift_feature_extractor.py'
""").df()