Run Query - Learn WorkflowDog

Run Query connects to a PostgreSQL account, executes one SQL statement, and returns its result rows and affected-row count.

Inputs

Input	Type	Required	Description
Third-party account	PostgreSQL account	Yes	Host, database, credentials, port, and SSL settings.
Query	String	Yes	A non-empty SQL statement.
Parameters	List of any values	No	Values bound to `$1`, `$2`, `$3`, and later placeholders in order.

select id, email
from customers
where plan = $1 and created_at >= $2
order by created_at desc;

Add pro as parameter 1 and the cutoff date as parameter 2.

Use parameters for values instead of joining untrusted text into SQL. Parameter placeholders protect values, but they cannot stand in for table or column names.

Outputs

Output	Type	Description
Rows	List of objects	Rows returned by the query. Each object uses column names as keys.
Row Count	Number	The number of rows returned or affected.

The database connection is closed after the query succeeds or fails.