New DuckDB Extension Launch!

I am happy to introduce the MiniJinja Extension for DuckDB, brought to you by Query.Farm!

Now you can bring the power of the industry-standard MiniJinja templating engine directly into SQL — no more clunky string concatenation.

With MiniJinja in DuckDB, you can:

✅ Generate dynamic HTML and reports inside queries ✅ Create configuration files and scripts from data ✅ Personalize notifications and messages at scale ✅ Use full template logic — variables, filters, loops, conditionals, and more

More details:

https://query.farm/duckdb_extension_minijinja.html

⚡️ Install in Seconds

INSTALL minijinja FROM community; LOAD minijinja;

✨ Example — Personalized output from JSON context:

SELECT minijinja_render(   ‘Hello {{ user.name }}, you have {{ user.messages }} new messages!’,   ’{“user”: {“name”: “Alice”, “messages”: 5}}’ );

You can even render from template files, enable HTML auto-escaping, or enforce strict error handling — all from SQL.

📌 Start templating smarter today — and make your SQL outputs shine.

Originally posted on LinkedIn.