DB: SQL Query (custom SELECT)

Description

Run a custom SELECT (with JOIN, GROUP BY, CTE) and return rows. Read-only — use db_insert/db_update for mutations.

⚙️ Configuration parameters

Fields shown in the editor when configuring the node. Generated directly from the NodeDefconfigFields.

💡 Configuration example

JSON snippet of the node as it appears in the workflow. Values are derived fromdefaultValue and from required parameters.

{
  "id": "node-db_sql_query-1",
  "defId": "db_sql_query",
  "label": "DB: SQL Query (custom SELECT)",
  "config": {
    "databaseId": "<databaseId>",
    "sql": "SELECT o.order_number, ol.product_description FROM orders o JOIN order_lines ol ON ol.order_id = o.id WHERE o.order_date >= date('now','-90 days') ORDER BY o.order_date DESC",
    "rowLimit": 5000
  }
}

🔗 Related nodes in the same category