sql

Transforms an input into a SQL insert statement. Typically paired with a stream channel that pipes into a database client.

The table name is taken from the table field on the associated effect's metadata. If that's not specified, it falls back to the effect's key.

#Parameters

None.

#Examples

User Insert

Given an input from the users effect with the following data:

{
  "id": 1,
  "name": "Alice",
  "admin": true
}

Produces the following SQL insert:

INSERT INTO `users` (id, name, admin) VALUES (1, 'Alice', true);