{"api_version":2,"name":"piflow_execute_sql_stop","version":"1.0","description":"Read-only SQLite SQL over a named input relation (not Spark SQL). Params: sql, viewName. Scalar inputs, max 128 MiB. Output types inferred; empty computed columns have null type.","icon":{"path":"M4 5h16v14H4zM8 9l3 3-3 3m5 0h4"},"inputs":{"source":{"representations":["records"],"formats":[]}},"parameters":{"type":"object","properties":{"viewName":{"type":"string","description":"Relation name used to expose the input to the query."},"sql":{"type":"string","description":"Read-only SQLite SELECT query."}},"required":["sql","viewName"],"additionalProperties":false},"runtime":{"image":"sha256:4b380edaef3b5a3f525a63a053b2aaa4e94c8bd89864cf1d7b77b6fed715e5d7","archive":{"sha256":"80371646a4717abb68152a72ae6ef46dfb169a3ba040254d43aa6e55fd062081","size":73818112,"filename":"runtime.tar"}},"execution":{"executor":"python","entrypoint":"dacp_piflow_execute_sql_stop","config":{}},"source_public":true,"provenance":{"source_archive":{"sha256":"8e1c6cc400de304220b27b17db1dcec46e69d66937e6c56f155de1400256a0b0","size":14800,"filename":"piflow_execute_sql_stop-sources.zip"},"license":"Apache-2.0"},"artifact":{"sha256":"e8ecb960b2363d87c880a88c9e53f88e114333c8cb814cbddee7bdf66653f313","size":30298,"filename":"operator.zip"},"categories":["Data processing","SQL"],"documentation":{"inputs":{"source":"Input records to process."},"outputs":{"result":"Run a read-only SQLite analysis query over the input relation."},"parameters":{"viewName":{"description":"Relation name used to expose the input to the query.","help":"Use this same relation name in the FROM clause.","example":"observations"},"sql":{"description":"Read-only SQLite SELECT query.","help":"Reference viewName; use SELECT and explicitly cast text columns when numeric operations are needed.","example":"SELECT station_id, AVG(CAST(temperature AS REAL)) AS mean_temperature FROM observations GROUP BY station_id"}},"example_job":"name: Run a read-only SQLite analysis query over the input relation.\nsteps:\n- id: read_source\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/example/source.csv\n    view: records\n- id: process\n  operator: piflow_execute_sql_stop@1.0\n  inputs:\n    source: read_source\n  params:\n    viewName: observations\n    sql: SELECT station_id, AVG(CAST(temperature AS REAL)) AS mean_temperature FROM\n      observations GROUP BY station_id\n- id: receive_result\n  operator: client_sink@1.0\n  inputs:\n    result: process\n"},"role":"transform","type":"sdk","outputs":{"result":{"view":"records"}},"trust":{"score":5,"assessed_by":"administrator","reviewed_at_ms":1793187761282},"publication":{"author":"dacp-examples","submitted_at_ms":1793178647722,"approved_at_ms":1793187761282,"last_submitted_at_ms":1793612008415,"last_approved_at_ms":1793612035272},"download_count":1}