Skip to content

FR: configuration to import custom python functions #158

@mjpieters

Description

@mjpieters

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions