# SQL Endpoint Properties

## `query` (string, required)

The SQL query used to write or to subscribe

Example: `"INSERT INTO test (some_column) VALUES ($some_column)"`

## `queryValues` (string)

The SQL query values used to bulk insert

Example: `"($id, $name, $age)"`

## `interval` (integer)

The amount of milliseconds between queries. Only required when subscribing

Default: `1000`

## `cronExpression` (string)

The Cron expression used to poll the endpoint. (For examples, see: <https://github.com/node-cron/node-cron>)

Examples: `"1,2,4,5 * * * *"`, `"1-5 * * * *"`, `"*/2 * * * *"`, `"* * * January,September Sunday"`