spiceai/docs

title: 'Prepared Statements' sidebar_label: 'Prepared Statements' pagination_prev: 'reference/sql/subqueries' pagination_next: 'reference/sql/explain' sidebar_position: 4

Prepared statements can use positional arguments to support multiple parameters. Each parameter is referenced by its position in the statement.

SQL Example

To create a prepared statement named greater_than with two parameters:

To execute the prepared statement with integer and double arguments:

Python Example

:::warning[Limitations]

Positional arguments are not supported with the date keyword to construct a date value, like date $1. Specify the date value in the query instead: l_shipdate > date '1995-01-01'.

:::

Prepared statements can use positional arguments to support multiple parameters. Each parameter is referenced by its position in the statement.

SQL Example

To create a prepared statement named greater_than with two parameters:

To execute the prepared statement with integer and double arguments:

Python Example

:::warning[Limitations]

Positional arguments are not supported with the date keyword to construct a date value, like date $1. Specify the date value in the query instead: l_shipdate > date '1995-01-01'.

:::