Ability to inject custom functions and use them in standard queries

[rajasekarshanmugam]

duckdb has a way to inject custom functions into the query engine and use the same function(s) in queries (using python as described here https://www.markhneedham.com/blog/2023/06/02/duckdb-dummy-data-user-defined-functions/). This is very useful to wrap custom algorithms, provide extended behaviors etc..

Is there any way by which we can inject functions implemented in .NET core? These could also accept arguments of native types (similar to the sample above).

Sqlite also provides similar capabilities and application defined functions can be injected via the connection and allows queries to use these similar to native functions (https://www.sqlite.org/appfunc.html.

[Giorgi]

This is currently not possible with .Net