litecli icon indicating copy to clipboard operation
litecli copied to clipboard

FR: configuration to import custom python functions

Open mjpieters opened this issue 2 years ago • 0 comments
trafficstars

LiteCLI is built in Python, and the Python bindings for SQLite make it possible to bind custom functions you can then call from SQL, see the Connection.create_function() documentation.

I'd love to see litecli support defining your own custom functions for use in SQL queries. This could be in the form of compiling the source code for such a function embedded in the config file, or to support importing functions from Python modules (I'd suggest a path:callable syntax, where you use importlib to import path, then get the callable name from the imported module to register as a functoin).

Bonus points if you can also register aggregation, window and collation functions!

mjpieters avatar Apr 20 '23 14:04 mjpieters