{% load crispy_forms_tags %} {% load crispy_forms_field %} {% load bloomerp %} {% load static %} {% breadcrumb title='Query builder' model=model %}

Query builder

{% if object %}{{ object.query }}{% else %}SELECT * FROM table_name;{% endif %}
{% for table in db_tables_and_columns %}
{{ table.0 }}
    {% for field in table.1 %}
  • {{ field.0 }}
  • {% endfor %}
{% endfor %}
{% include 'snippets/llm_modal_snippet.html' with modal_id='sqlQueryGenerateModal' title='Generate SQL query' target="#llm_output" query_type="sql" %}