SQL Query Row
Through the SQL query row action it is possible to write an arbitrary SQL query which gets returned as response. It is
possible to pass path and query parameters into the query by using curly brackets i.e. title
. These fields are
internally replaced by a prepared statement so you dont need to worry about SQL injections.
Example
SELECT *
FROM contract
INNER JOIN product
ON contract.product_id = product.id
WHERE product.id = {id}