.. _auto_sql_group:

* SQL GROUP HANDLER*
====================

Queries and groups structured CAE simulation data from a SQL-backed store, supporting four extraction modes: summary, material, part details, and contact. Use this worker to retrieve and consolidate tabular simulation metadata or results into a single bulk output for downstream processing.

When to use
-----------

Classification: **process**.

Tagged: ``bulk``, ``contact``, ``extraction``, ``group``, ``material``, ``part_details``, ``query``, ``sql``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Type Of Extraction
     - Type of Extraction
     - string
     - summary
     - 
     - Selects the category of data to extract and group from the SQL store; choose 'summary' for high-level simulation results, 'material' for material property records, 'part_details' for per-part geometry and attribute data, or 'contact' for contact interface definitions. Defaults to 'summary'.

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - sql_group_output_1
     - sql_group_output_1
     - bulk
     - Bulk tabular dataset containing the grouped and extracted records corresponding to the chosen extraction type; consumed by downstream transform or reporting workers.

Disciplines
-----------

- data.dataset.transform
- data.io.sql

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>sql_group</code>. Schema hash: <code>08c59a7cf649</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>