{"name":"piflow_execute_sql_stop","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},"api_version":2,"version":"1.2","source_public":true,"execution":{"executor":"python","entrypoint":"xstream_piflow_execute_sql_stop","config":{}},"runtime":{"image":"sha256:40db7fee594f1452790d1cc99c2e5429e187eb64633c716b8c6f903c47576975","archive":{"sha256":"e1844833e35390f2eaf9fc9ec7b67057ad0305ad713c0da6c8b055980a66946c","size":73825792,"filename":"python-arrow-2.0-runtime.tar"}},"dependencies":{"provider":"python"},"provenance":{"source_archive":{"sha256":"599b7fe77402f75e31dcda9f530d317222f57615eb952b362ba50065f1fd5c64","size":8339,"filename":"piflow_execute_sql_stop-1.2-sources.zip"},"license":"Apache-2.0"},"artifact":{"sha256":"105ec604240b93ca70a2dd1229d788a59293c615666a22ed897d9b5f564cf69e","size":9699,"filename":"operator.zip"},"environment":{"fingerprint":"f268a49bef227062fbf35d40627d5ff6e44d4558cbeaa253359f97651e32828c","image":"sha256:451e7ab496c06cc4198078b0dae8e545f50842c39ea5d23c5eefc6c2ce68e8c2","archive":{"sha256":"e086e3ee88de7f8dba45ca317a0332ced7b55fec45fc8bb43a5934dac7c3204d","size":73827328,"filename":"environment.tar"},"lock":{"provider":"python","version":1,"platform":"linux/amd64","files":[{"path":"python/.lock","sha256":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"}],"requirements":""}},"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.2\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":1793514282628},"publication":{"author":"dacp-examples","submitted_at_ms":1793514276901,"approved_at_ms":1793514282628,"last_submitted_at_ms":1793612008415,"last_approved_at_ms":1793612035272},"download_count":1}