{% load static %} {% load crispy_forms_tags %} {% load crispy_forms_field %}

Query builder

{% if form.errors %} {{form.errors}} {% endif %}
SQL Magic Filter
{% if object %}{{ object.query }}{% else %}SELECT * FROM table_name;{% endif %}
{% for table in db_tables_and_columns %}
{{ table.0 }}
  • {{ table.0 }} (table) Select
  • {% for field in table.1 %}
  • {{ field.0 }} ({{ field.1}}) Select
  • {% endfor %}
{% endfor %}
{% include 'snippets/llm_modal_snippet.html' with id='sql_query_generate' modal_id="sql_query_generate_modal" title='Generate SQL query' target="llm_output" query_type="sql" %}