DuckDB MiniJinja Extension by Query.Farm

The MiniJinja extension, developed by Query.Farm, brings powerful template rendering capabilities directly to your SQL queries in DuckDB. Generate dynamic text, HTML, configuration files, and reports using the robust MiniJinja templating engine without leaving your database environment.

Documentation

Full documentation, including installation, usage, the function reference, and cookbook examples, is available at:

https://query.farm/products/extensions/minijinja

Installation

INSTALL minijinja FROM community;
LOAD minijinja;

Render a context from columns

Use minijinja_render_with_context when supplying JSON context, including values constructed from columns. minijinja_render is the entry point without context; its additional option arguments must be constant expressions.

SELECT minijinja_render_with_context('Hello {{ name }}!', json_object('name', name))
FROM (VALUES ('Ada'), ('Grace')) AS users(name);
-- Hello Ada!
-- Hello Grace!