While chasing down performance and cleaner code, I've ran into this problem I've found that UDF's are seemingly connection dependent, not database dependent. If I, for instance, used a trigger on insertion using adbc_ingest(), but the UDF is defined within an sqlite3 connection, it would fail, giving me this kind of error:

adbc_driver_manager.InternalError: INTERNAL: failed to prepare: no such function: example_function

Therefore, my method of using a normal sqlite3 connection along with an adbc connection will not work. I was wondering if there was any way to register UDF's via the adbc API directly, as the documentation for adbc doesn't seem to highlight UDF creation anywhere.