jinja_sql_prepared_statement.py

from jinjasql import JinjaSql
j = JinjaSql()

j.env.filters['alias_column'] = alias_column
j.env.filters['name_column'] = name_column

template = """
SELECT
    {{ columns |map('alias_column')| join(',\n') }}
    
FROM {{table_name}} a
{% if where != None %}
WHERE 
    {{where}}
{% endif %}

GROUP BY
{{ columns | map('name_column') | join(',\n') }}
"""

data = {
    "table_name": 'test_02',
    "columns":columns,
    "where":"category = 'test'"
}
query, bind_params = j.prepare_query(template, data)