Adds templating to DuckDB, enabling dynamic generation of text, HTML, and reports directly within SQL queries using the Tera engine.
Maintainer(s):
rustyconover
Installing and Loading
INSTALL tera FROM community;
LOAD tera;
About tera
For more information regarding usage, see the documentation.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| tera_render | scalar | Renders a Tera template string with JSON context variables | NULL | [tera_render('Hello !', '{"name": "World"}'), tera_render('', '{"value": "hello"}')] |
| tera_render | scalar | Renders a Tera template string without context variables | NULL | [tera_render('Hello World!')] |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases | |——|————-|————|——-|———|