SQL

SQL allows for a custom SQL expression to be executed against table(s) inside a Workflow. The supported syntax is PostgreSQL and is executed using DuckDB.

Example SQL expression

SELECT CustomerId, SUM(Sales) 
FROM "order-details" 
WHERE State = "CO" 
GROUP BY 1 
ORDER BY 2 DESC 
LIMIT 10