.. _auto_sql_query_table:

*QUERIES AN SQL TABLE*
======================

Executes an arbitrary SQL query against an existing platform database table and returns the results as both a formatted string preview and a dataset object. Use this worker to read, filter, or manipulate data stored in SQL tables within the d3VIEW platform; non-SELECT queries (INSERT, UPDATE, DELETE) are also supported but do not produce row outputs.

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

Tagged: ``database``, ``db``, ``query``, ``select``, ``sql``, ``table``, ``workflows``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Query
     - query
     - textarea
     - —
     - ✓
     - Full SQL statement to execute (e.g. SELECT, INSERT, UPDATE, DELETE); must reference an already-existing table — use the create_sql_table worker first if the target table does not yet exist. Code-editor mode is enabled for multi-line authoring.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - Status
     - status
     - string
     - Human-readable string indicating whether the query succeeded (including the executed statement) or failed (including the error message); always populated regardless of query type.
   * - Results
     - results
     - string
     - Plain-text preview of the SELECT query result set, capped at the first 10 rows with a header noting total vs. hidden row counts; only populated when the query returns at least one row.
   * - Results Dataset
     - results_dataset
     - dataset
     - Full result set of a SELECT query as a structured dataset object (array of row objects) suitable for downstream dataset-aware workers; only populated when the query returns at least one row.

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

- data.io.sql

.. raw:: html

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